Excel 2000 versus 2003 and the TEXT Function
I have an incompatibility between Excel 2000 and 2003 and I want to
understand why. I have the formula
=TEXT(12, "N00")
In Excel 2000 I get
N12
In Excel 2003 I get
#Value!
and Excel 2003 indicates the error as "A value in the formula is of the
wrong data type." If I change the formula to
=TEXT(12, "\N00")
Then I get
N12
for Excel 2003. Why do I need the back slash and what am I telling TEXT
about the format by adding the back slash?
Art
|