Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |