number stored as text
 

Hi,

Using VBA How can I check if number stored as text in cell. I have a long
list, converting whole list is time consuming, I want to identify trouble
cells and change.

Atif

number stored as text
 

Select the column with the cells in question and then just execute these two
lines from the Immediate Window (you can bundle them into a macro if you
really want to though)...

Selection.NumberFormat = "General"
Selection.Value = Selection.Value

NOTE: The above code assumes your values are constants and that there are NO
formulas within the selection.

--
Rick (MVP - Excel)


"Atif" wrote in message
...
Hi,

Using VBA How can I check if number stored as text in cell. I have a long
list, converting whole list is time consuming, I want to identify trouble
cells and change.

Atif