View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art H Art H is offline
external usenet poster
 
Posts: 26
Default 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