I have a quick problem that I need some help with. I have a range of numbers
that are formatted as text. Basically, for any formulas to work, I need to
delete one space from the beginning of each cell, and one space from the end of
each cell. Something like this (In text format): " -5,000.00 " needs to be
"-5000.00". Is there a simple way to trim the cell so it results in a numeric
value instead of text?
Accounting/Control Section Manager
The Northern Trust Corporation