Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how am i able to store a number as text? (ADO related)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how am i able to store a number as text? (ADO related)
:-) *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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I store frequently used text in Excel for auto-complete? | Excel Discussion (Misc queries) | |||
Need help with Excel 2000 text-related functions | Excel Worksheet Functions | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
Access data base is able to store any number of records | Excel Worksheet Functions | |||
Store row number after a find | Excel Discussion (Misc queries) |