GORDON SCALES via OfficeKB.com
Guest
Change negative sign from end of number to the beginning of the number.
I need to scan financial reports to a file so that I can then manipulate
columns of figures. I can do this using an OCR program and saving as an
Excel file.
The reports have the negative sign at the end of the number but Excel
requiires it at the begiinning.
eg: 1234.56- needs to convert to -1234.56
Is there a way that I can convert a whole column
--
Message posted via http://www.officekb.com
Bookmarks