# in Function
Hi,
try to use
=text(c2,"#000 0")
hth
regards from Brazil
Marcelo
"CIL" escreveu:
Top of the morning.
The below function inserts a space between the last 2 digits of a number.
6789 in a1 becomes 678 9 and aligns on the left of the cell (text).
=TEXT(A1,"#"" ""0")
Now for the dumb question, what does the "#" do and where could I find this
tidbit of information?
Thanks.
cil
|