Number formatting

[Guest]

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

 

[JulieD]

Hi ZB

i think the following gives you what you're after

 

[JulieD]

Hi

i'll try that again ... use

 

[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")

 

[Guest]

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

 

[JulieD]

you're welcome and thanks for the feedback