Converting text col to numbers if necessary

[welchs101]

I have 3 sheets. On each of the sheets there is a col labeled LOT#. Most of the time the values in the col for Lot# are numbers. However, some of the time the values are actually "text". Is there a way to test to see if the numbers are "text" and if so is there an efficient way to convert the col of values to numbers?

any help would be appreciated.

thanks.

[MarvinP]

Hi,

Add a zero to all the numbers and they will convert to numbers. Do this in a separate column and then copy and paste values only back over the original.

[jaslake]

Hi welchs101

You don't indicate what or how your doing what you're doing...if you're using VBA to reference the cell, you might try

Please Login or Register  to view this content.

[welchs101]

I came up with the following code

Please Login or Register  to view this content.

The first part just converts range to "number format" 2nd part actually converts text to number...........but its really really slow.........is there a faster way?

[welchs101]

i assume there is not faster more efficient way to do this ........right?