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


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