:-) *yay* solved problem

1. If the value is emptied first.
2. Set the format text.
3. Put value in cell.

"Beth" wrote in message
...
Hi everyone,

I am trying to store numbers as text programmatically in excel. (I don't
know how to store data was stored before, this is for fact finding)

The background error checking in excel has detected some cells have been
stored as text. i can use SQL to search on these values and the value
appears as text correctly.

If I edit the number to a text value the data becomes numeric by default,
though i've specified 'text'.

ActiveCell.Value = '102' - will store the data as a numeric, and am unable
to search for the data using an SQL query :-(

Thank you in advance.
Bethany