I'm rendering a matrix into Excel and have found that whenever I use the Format function on a cell I then get 'Number Stored as Text' message in Excel - it's the green triangles everywhere that make it look really ugly.
I want to use Format as I am carrying out a division of one value by another in this cell and would like to, at a minimum, display the value to 2 decimal places, or ideally as a nice percentage.
Without Format it renders fine. Using FormatPercent, or Format to P2, N2 etc, I get the message.
Any ways to deal with this would be greatly appreciated!