View Single Post
  #1   Report Post  
Frustrated Excel user
 
Posts: n/a
Default Converting negative/positive numbers to a CSV (Comma-delimited .TX

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