Number formatting

Z

ZB

Hi,
I am need to convert numbers from my excel file to a text file where the
number needs to show up as follows:

###############.##

So for $401.11 the amount formula should read " 401.11"
If the number is negative, it should read " -401.11"

Is this doable?
Thanks
ZB
 
J

JulieD

eek .. computer's gone mad - it keeps sending stuff and i promise i'm not
doing it ....

here's the formula

=REPT(" ",15-LEN(A1))&TEXT(A1,"##.00")
 
Z

ZB

I came up with an "if" function, but this is a million times more elegant and
a lot less likely to create errors.

Thanks a lot... and have a great weekend!
-ZB
 
Top