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 (FORMATCELLSNUMBERSFORMAT_CODES); for example:
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
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)