| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel macro to move minus sign
I am importing numbers that has the minus sign to the right of the number. I
need a macro that can move the minus sign to the left of the number. I used to have one but must have copied in incorrectly. What I has so far is.. Sub move_minus_left() Dim currentcell As Object For Each currentcell In Selection If Right (currentcell.Value, 1)="-" Then currentcell.formula="-"&left. I really really need help with this as soon as possible. Thank you Very Much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minus Sign | Excel Discussion (Misc queries) | |||
| Excel 2007 - display negative numbers with minus sign and parenthe | Excel Discussion (Misc queries) | |||
| I do not want the minus sign | Excel Worksheet Functions | |||
| minus sign | Excel Worksheet Functions | |||
| excel macro to move minus sign | Excel Programming | |||
Threaded Mode
