Moving minus sign from back to front of number

  • Thread starter Thread starter Paula
  • Start date Start date
P

Paula

We are importing data from our accounting software into
Excel and unfortunately, the - for negative numbers is
behind the number instead of in front of it. Therefore,
Excel does not read it as a negative. Is there a way to
to make these numbers read and calculate as negatives
short of manually going in and changing each and every
one? Thanks.
 
Paula, try this =IF(RIGHT(A1)="-",LEFT(A1,LEN(A1)-1)*-1,A1+0)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Paula

If you have Excel 2002 you go to Data>Text To Columns and Next>Next>Advanced.
See checkbox for "trailing minus signs".

Gord Dibben 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

Switching negative signs from back to front 4
Excel 2007 - display negative numbers with minus sign and parenthe 3
strip minus signs from right to left 2
change negative sign from end of the number to the begining 11
how to convert text with trailing minus sign to number 4
Minus sign trouble 1
How to remove a - sign after the number 9
find/replace "cr" from end of number to "-" in front of number 2

Back
Top