John Heinrich wrote:
>
>
> I'm using OpenOffice.Org under Windows XP. I have entered a TEXT function
> of the form
>
> TEXT(number;format) as specified in the onboard help. I have (for example)
> referenced a value in cell B32 and used a format code from the number
> format window (FORMAT>CELLS>NUMBERS>FORMAT_CODES); for example:
> TEXT(B32;###.##), or TEXT(B32;000.00). But it doesn't accept the
> formatting. When using format code ###.##, the function returns #NAME?
> when using 000.00 it returns the number (B32) rounded to the next highest
> whole number, and it converts the format code I entered (000.00) to a
> single zero (0). Where can I find a list of acceptable formatting codes,
> or how do I correct this error?
>
>
Some skill at mind reading is required. The format needs to be within
inverted commas:
=TEXT(B32;"###.##")
--
View this message in context:
http://www.nabble.com/Using-TEXT-function-tf3133313.html#a8682168
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
