98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Labels and Vlaues
Labels and Vlaues
Resolved · Low Priority · Version 2003
Ash has attended:
Excel Introduction course
Labels and Vlaues
Why do labels default to the left and values default to the right on excel spreadsheets?
RE: Labels and Vlaues
Hi Ash,
Thank you for the post, welcome to the forum, I hope you enjoyed todays course.
To answer your question;
Sometimes numbers can look like numbers when they are infact text. ie a number which has been formatted as text.
All numbers should be right aligned by default
If numbers are left aligned then they are probably being interpreted as text.
It is not possible to perform calculations on any numbers that are being interpreted (or formatted) as text
Dont forget if you dont want them different all you need to do is to select them and apply either left, right or centre alignment,
Hope that helped, regards Pete
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:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |