Home |
Search |
Today's Posts |
#1
|
|||
|
|||
converting minus quantities to plus
I download my bank statements and store them in Excel. the bank has the
annoying habit of displaying debit items as minus quantities with a minus sign attached. this makes it awkward for manipulating the figures afterwards. I've tried displaying them in red but they are still shown with a minus in the bar at the top.is there a way of mass converting this row of minus figures into ones without the minus sign? I know there is probably a simple way of doing this but I can't figure it out.i have Windows XP Home Edition. thanks Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting CSV files into Excel files | Excel Worksheet Functions | |||
how to color code a cell in excel if amount reaches a minus | Excel Discussion (Misc queries) | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
minus formel/fortegn | Excel Discussion (Misc queries) |