formatting negative numbers

  • Thread starter Thread starter peggy
  • Start date Start date
P

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
 
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.
 
Back
Top