excel macro to move minus sign

S

steve1961

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!
 
R

Rowan

One way without a macro.

Select the data then Data>Text to Columns. Click Next twice to take you
to the Step3 screen. Click on Advanced. Make sure Trailing Minus for
Negative Numbers is checked. Click Ok and then Finish.

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel macro to move minus sign 2
minus sign 3
How to followhyperlink to a folder with a minus sign in the name 1
Cut, paste and delete 1
Move cell focus in VBA 1
The directory property cannot be found in the cache 8000500d 0
Combobox and spinbutton causing object disconnected error 2
Word macro that can call cells out of Excel for a find and replace 0

Top