You could use the custom format +###.#;-###.# In Excel the formats are
composed of 3 parts separated by semi-colons: positive;zero;negative. Would
you be better off padding all the numbers with leading spaces so that they
are all the same length?
Something like = REPT(" ",6-LEN(A1))&A1
where A1 contains your number and 6 is the max length of text you want.
--
Simon
"Frustrated Excel user" wrote:
> If I have numbers in a column in an Excel spreadsheet and I want to import
> those numbers into another application (IBM Mainframe), so I have to convert
> the numbers to a comma-delimited .TXT file, how do I keep all the numbers
> aligned together? My problem is that when I convert it, it misaligns the
> negative versus positive numbers. For example:
>
> 2.0
> -005.2
> -006.5
> 115.9
> When I convert these, I would like them to line up as follows in the .TXT
> file:
>
> 2.0
> -005.2
> -006.5
> 115.9
>
> What happens is I see them as this:
> 002.0
> -005.2
> -006.5
> 115.9
>
> My columns are set up as "Custom" with ###.# as their format.
>
> Any suggestions? Is there a way to change the default to where it shows
> negatives with a minus sign and positives with a plus (which might line them
> up correctly)?
Bookmarks