| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting 123 CR & 4567 DB to 123 & -4567
My financial report with several columns and all the rows displays numeric
values as text with DB and CR that I need to convert to positive and negative numerics. The following function does the job, but is there a macro available that would do it? =IF(RIGHT(E12,3)=" cr",1*LEFT(E12,LEN(E12)-3),-1*LEFT(E12,LEN(E12)-3)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting ASC to csv | Excel Discussion (Misc queries) | |||
| Converting to PDF | Excel Discussion (Misc queries) | |||
| converting | Excel Discussion (Misc queries) | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Converting .xls to .doc | Excel Discussion (Misc queries) | |||
Threaded Mode
