Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
Converting Numbers | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions |