Macro
 

My macro convert sell with value '0001' to '1'. Need help!!!

Macro
 

Let us asume that cell A1 contains 0001 as a text string. The following
macro will convert to the number 1:

Sub changeIt()
Cells(1, 1).Value = Cells(1, 1).Value * 1
End Sub

If, however, the 0001 is actually a number, then just change the format to
remove the leading zeros.
--
Gary''s Student


"Zhanna" wrote:

My macro convert sell with value '0001' to '1'. Need help!!!