I often get receive data in the form 100- which tells me that the value
is negative 100.

In order to use this data properly i need to have the '-' at the front
so it can be treated as a number.

Can anyone tell me how i can create a macro to do this - it would be
much appreciated


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements