I didn't even know there was such a function, so I had to play around with it a bit first. I found that you have to write the format within quotes:
=TEXT(B32;"###.##") and =TEXT(B32;"000.00") both works fine for me. This example also worked for me: A1: =12,3456789 A2: ###.## B1: =TEXT(A1;A2) Now A2 doesn't need the quotes. However, if you enter 000.00 in A2 it will immediately be replaced by 0. To stop that from happen, just write a ' right before the format: '000.00 Of course you could also write: ="000.00" in A2. Maybe this last example was not exactly what you were looking for, but it seems to be nice when experimenting with different formats. Just change A2 and see what happens with B1 directly. Another way to experiment is of course to use the function guide (Ctrl+F2). I use it all the time when I am not sure about how to use a function. A few days ago, I had to write formulas in Excel and I really missed the function guide there. Maybe there is one, but I certainly couldn't find it. Johnny 2007/1/29, John Heinrich <[EMAIL PROTECTED]>:
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?
