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