98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultancy - Numbers in excel
excel consultancy - Numbers in excel
Resolved · Low Priority · Version Standard
Tue 21 Aug 2007, 09:53Delegate Rachel said...
Rachel has attended:
PowerPoint Introduction course
Excel Intermediate course
Numbers in excel
If you want to input say a telephone number into excel how do you stop the programme thinking it is a formula?
Wed 22 Aug 2007, 05:28Trainer Tracy said...
RE: Numbers in excel
Hi Rachel,
Thanks for the question.
There are two ways you can do this. Firstly you can change the setting of the cell to 'text' and then you can type in the number. Alternatively you could start the cell with an apostrophy (') this will cancel out the =.
Good luck
Tracy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |
