excel-xp-training - cell formating

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Cell formating

excel-xp-training - Cell formating

resolvedResolved · Low Priority · Version Standard

Katie has attended:
Excel Intermediate course

Cell formating

sometimes when you change the type of value of the numbers in the cell - e.g. from currency to text/number and you make it 0 you get a green comment tag. Why is this?

RE: cell formating

Hi Katie

Thank you for your question.

This tends to happen when you change the format of a cell from something that Excel recognises as a number to something Excel recognises as text.

The reason it brings up the green triangle is to alert you to this, as once a value is formatted as text it cannot be used in a formula. So if you have formulas in the spreadsheet that refer to this cell, this value won't be included as part of the calculation if the value is changed.

I hope this helps.
Amanda

 

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.


Server loaded in 0.08 secs.