Format Same Length Always?
 

I'm writting a spreadsheet that prepares an input text file for
program originally written in Fortran. This program requires all inpu
to be 10 digits long, no exceptions.

So, if the number does not have 10 digits, it needs spaces (or zeros
in front. If it is negative, it needs to save room for the "-". I
the number is large, and needs to be in scientific notation, th
exponent and its sign must fit.

Does anyone know how to make a number format that always fills up te
spaces no matter how large or small the number, positive or negative?
Right now I have a complex series of conditionals that is ver
confusing.

Thanks!

--Da

--
Message posted from http://www.ExcelForum.com