Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable formatting
Hi,
I wrote an excel/html output from a database, but when it gets imported, the housenumbers that are formatted like "9/13" or "13-17" get formatted as a date. Is there a way to turn this of, or to make sure this doesn't happen? Regards Tim De Vogel S-Data NV |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable formatting
Answer would depend on the exact method you are using to
import it (Text file? External data query via ODBC? VBA routine?) However, it might just be simpler to set up a routine to format that column as text after the import - it will force Excel to read treat your housenumbers as text. -----Original Message----- Hi, I wrote an excel/html output from a database, but when it gets imported, the housenumbers that are formatted like "9/13" or "13-17" get formatted as a date. Is there a way to turn this of, or to make sure this doesn't happen? Regards Tim De Vogel S-Data NV . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable formatting
I don't import it, I export to the html/excel format that microsoft supports
(where each cell in a table of html is viewed as a cell in excel). It has the extension .XLS and excel opens it just like it would open up a normal excel file. Is there a place where you can point me at that has some info on such a routine? --- Tim De Vogel S-Data NV "K Dales" schreef in bericht ... Answer would depend on the exact method you are using to import it (Text file? External data query via ODBC? VBA routine?) However, it might just be simpler to set up a routine to format that column as text after the import - it will force Excel to read treat your housenumbers as text. -----Original Message----- Hi, I wrote an excel/html output from a database, but when it gets imported, the housenumbers that are formatted like "9/13" or "13-17" get formatted as a date. Is there a way to turn this of, or to make sure this doesn't happen? Regards Tim De Vogel S-Data NV . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable formatting
The VBA code would be:
Sheets(SheetName).Range(RangeName).NumberFormat="@ " Where SheetName is the name of the worksheet and RangeName is the name (or address) of the range including your housenumbers - example: Sheets("Import").Range("C:C").NumberFormat = "@" You could set this up as a macro. -----Original Message----- I don't import it, I export to the html/excel format that microsoft supports (where each cell in a table of html is viewed as a cell in excel). It has the extension .XLS and excel opens it just like it would open up a normal excel file. Is there a place where you can point me at that has some info on such a routine? --- Tim De Vogel S-Data NV "K Dales" schreef in bericht ... Answer would depend on the exact method you are using to import it (Text file? External data query via ODBC? VBA routine?) However, it might just be simpler to set up a routine to format that column as text after the import - it will force Excel to read treat your housenumbers as text. -----Original Message----- Hi, I wrote an excel/html output from a database, but when it gets imported, the housenumbers that are formatted like "9/13" or "13-17" get formatted as a date. Is there a way to turn this of, or to make sure this doesn't happen? Regards Tim De Vogel S-Data NV . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to disable General formatting when opening CSV | Excel Discussion (Misc queries) | |||
Disable formatting on csv open? | Excel Discussion (Misc queries) | |||
How do I disable email formatting. | Excel Discussion (Misc queries) | |||
Disable Excel's Auto Formatting | Excel Programming | |||
Disable auto editor formatting | Excel Programming |