Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Cell formating
|
|
|
The UK's most regular 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-xp-training - Cell formating
Resolved · Low Priority · Version Standard
Reply Thu 6 Dec 2007, 17:07Delegate Katie said...
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?
For upcoming training course dates see: Pricing & availability
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
|