Excel 2003 - negative following the number

O

ohdharleyboy

Hello all-

I have imported a column of numbers into an Excel 2003 spreadsheet from an
in house program. When there is a number in the column that is negative, it
displays the negative sign after the number (45.50- instead of -45.50). Is
there a way to move the negative sign for the entire column to the front of
the number? Thanks - Jason
 
G

Gord Dibben

Data>Text to Columns>Next>Next>Advanced "Trailing minus for negative numbers"

Make sure you checkmark the option to "on"

Then Finish


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Negative number format 5
Negative Numbers 8
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
column of negative numbers into positive numbers 2
Switching negative signs from back to front 4
Formatting negative percent 12
Why doesn't my Excel '03 let me use brackets for negative numbers 2

Top