Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all
I have the code below in Access which exports data into an existing Excel spreadsheet. The cells are formatted as general number but the code changes them to date format. Is there a way to specify the data type before the copy or should I try and find some code to format the cells after the export code has run? Thanks in advance for any help. Sue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text formatting | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
2 Questions | New Users to Excel | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
Formatting data | Excel Discussion (Misc queries) |