labels

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Labels and Vlaues

Labels and Vlaues

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips


Server loaded in 0.08 secs.