MrExcel Publishing
Your One Stop for Excel Tips & Solutions

convesrion of imported data


Posted by eric grant on January 26, 2002 9:03 AM

The data comes in with trailing minus. I need to convert to leading minus to calculate in Excel. Any suggestions?


Posted by Aladin Akyurek on January 26, 2002 9:10 AM

=IF(ISNUMBER(A1),A1,("-"&LEFT(A1,LEN(A1)-1))+0)

where A1 houses the first entry to convert. Copy down this as far as needed.