VBA to see If cell value is text/number

[Siyanna]

Hello All,

Is there a VBA function which can check to see if a cell is a string or number?

I.e say had dates and numbers in A1:A10

Although some might look the same, they might be numbers and strings.

Is there a way i can check to see what they are (Numbers/Strings).

Is there also a quick VBA way to convert them all to a string or Number depending on which one i want?

Cheers

 

[Siyanna]

It returns the text that is displayed in the cell itself, not the value that is behind it (which can be different).

Thank You