MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Negative Number Help


Posted by John H on September 15, 2001 11:04 AM

I download financial data for use in Excel, unfortunately the downloads come across with the negative numbers having a minus sign after the number, such as 33444.00-. Excel does not recognize this as a number and it can't be used in mathematical formulas. Converting the cell to numeric format in Excel doesn't help. Excel seems to treat the number as text. I believe the number needs to be changed to a true negative number with the minus sign infront of the number, such as -33444.00. I cannot figure out how to do that. Is it possible???

Thanks for the help.


Posted by Aladin Akyurek on September 15, 2001 12:09 PM

See: 30318.html