excel-xp-training - 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