Compile error, Syntax error
Hello from Steved
In Col B:B I'm asking to be removed the leading "0" ie 07075601 to be 7075601
Thankyou.
"OssieMac" wrote:
Not sure what you are trying to do. Can you post a sample of the source data
and a sample of the result that the formula should return.
--
Regards,
OssieMac
"Steved" wrote:
Hello from Steved
I should know but I'm not thinking to clearly.
I am getting a Compile error, Syntax error for the below why I thankyou.
Sub Removezero()
ActiveCell.FormulaR2C3 = "=MID(B2,1+(LEFT(B2)="0"),99)"
End Sub
|