how am i able to store a number as text? (ADO related)

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

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
 
:-) *yay* solved problem

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number stored as text 4
How to prevent a number stored as text from converting to a number 2
ADO with mixed data 2
Number Stored As Text 2
Numbers stored as text 2
Number Stored as Text. 2
number stored as text 1
custom function to convert numbers stored as text 4

Back
Top