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" wrote:

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


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"ZB" wrote in message
...
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