Converting TEXT to NUMBER in VBA

[Joe4]

OK, I should know how to do this, but it is late in the day and I must be having a brain cramp!

On my Excel spreadsheet, I have a TEXT value in A1 that is all numbers, i.e. "000065200". I would like to write some VBA code that changes A1 to the numeric value . How do I do this?

 

[sonofajim]

Nice find! Thanks for posting. Just what I needed for a similar problem.

 

[abhisek]

Try below code in subroutine :

Number = cint(activecell.value) ' will take the value from excel ie "000065200" and store 65200 in Number variable..

Thanks
Abhishek

 

[webflow]

For Each xCell In Selection
xCell.Value = CDec(xCell.Value)
Next xCell

 

[xlneedy]

For Each xCell In Selection
xCell.Value = CDec(xCell.Value)
Next xCell

CDec worked like a charm.. Thanks webflow