Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to automate sending values from an SQL Server database to
an Excel sheet. I don't want Excel to 'translate' these values at all. I want them to be placed into Excel Cells *exactly as they are written in the database*. Here's the situation: This database happens to have a column of values which read like this, for example: 1-55 1-56 .... In the database in question, these values have nothing to do with Date values. Nevertheless, Excel is receiving the above text and automatically treating them as if they *are* date values. For example, the cells above end up displaying in their Excel cells as Jan-55 Jan-56 If you click on a cell, you can see in that upper 'bar' area (the Excel textbox area just to the right of the 'fx' label) that my values are appearing as: 1/1/1955 1/1/1956 ....even though all I programatically entered into the cells were the '1-55' and '1-56' text values from my database. How do I STOP Excel from 'interpreting' my incoming values so that the incoming values are placed *literally* into Excel cells? Thanks in advance for any/all feedback. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop automatic formatting of cells (number, text, date, etc) | Excel Worksheet Functions | |||
Is it possible to get Excel to stop formatting text as a date? | Excel Discussion (Misc queries) | |||
Formatting dates with =TEXT() | Excel Discussion (Misc queries) | |||
How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) | |||
How do I stop auto converting Text(Inventory#) to Dates | Excel Discussion (Misc queries) |