| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change positive number to negative number | Excel Worksheet Functions | |||
| How do I change the sign of a base number for use in XIRR? | Excel Discussion (Misc queries) | |||
| change negative sign from end of the number to the begining | Excel Discussion (Misc queries) | |||
| Change Number to a negative in VBA | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Threaded Mode
