formatting negative numbers

[peggy]

I'm saving a file as a space delimited (.prn) for a
preprocessor. I have used the rept function to left fill
my numbers to 15 characters. Only problem is if the
number is a negative, it looks like this

000000000-42.00

Any suggestions?

Thanks

 

[jaf]

Hi Peggy,
Change the format to 000000000000000;-000000000000000 and Excel will display
the neg. sign IF the value is negitive.
Place the decimal point in the above where you need it.