move '-' from back to front???

  • Thread starter Thread starter jack27
  • Start date Start date
J

jack27

I often get receive data in the form 100- which tells me that the value
is negative 100.

In order to use this data properly i need to have the '-' at the front
so it can be treated as a number.

Can anyone tell me how i can create a macro to do this - it would be
much appreciated
 
Jack,

This code does it for the active cell. Just adapt to the range of cells
applicable

With ActiveCell
.Value = Right(.Value, 1) & Left(.Value, Len(.Value) - 1)
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

jack27 said:
I often get receive data in the form 100- which tells me that the value
is negative 100.

In order to use this data properly i need to have the '-' at the front
so it can be treated as a number.

Can anyone tell me how i can create a macro to do this - it would be
much appreciated


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
With your data in A1 enter into B1 =LEFT(A1,LEN(A1)-1)*-1
and copy down then Copy Col B to Col B using Paste-Special -Values, OK
HTH

jack27 said:
I often get receive data in the form 100- which tells me that the value
is negative 100.

In order to use this data properly i need to have the '-' at the front
so it can be treated as a number.

Can anyone tell me how i can create a macro to do this - it would be
much appreciated


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
I often get receive data in the form 100- which tells me that the value
is negative 100.

In order to use this data properly i need to have the '-' at the front
so it can be treated as a number.

Can anyone tell me how i can create a macro to do this - it would be
much appreciated
Click to expand...

If you have Excel 2002, you can use the Data/Text to Columns wizard


--ron
 
Back
Top