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 » Converting a number display
Converting a number display
Resolved · Low Priority · Version 365
Mon 9 Jan 2023, 10:53Delegate Paul said...
Paul has attended:
Excel Intermediate course
Project Management - Framework & Processes course
Converting a number display
how do you convert a number in a cell shown as 5,000 and set as general to a number that can be used to create formulas etc. ?
Mon 9 Jan 2023, 15:27Trainer Marius said...
RE: converting a number display
Hello Paul,
Thank you for your question. As long as Excel recognises the number as a number, the formatting doesn't matter. You will be able to use such a number in formulas.
To check if the number is actually a number, select the cell containing the number, then have a look in the Formula bar above. Any number will have a 'general' appearance there. E.g. in the cell, it might display as 5,000 but in the Formula bar, it will show as 5000.
To change a number's formatting, go to the drop-down in the Number group in the Home ribbon, then select General, etc.
If this reply doesn't answer your question, please do post again.
Kind regards
Marius Barnard
STL
Mon 16 Jan 2023: Automatically marked as resolved.
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:Copying Values Without Formulas in Excel 2010If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method: |
