Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get rid of single quote in field from Access export
I am exporting from Access to Excel and ending up with a single quote in
front of the dates--which makes them a text field. This matters because I am using the dates as a row source for a chart. If Excel knows they are Friday dates, it fills in the missing Friday dates for me (which is what I want). I have tried selecting the cells and formatting them as date fields and that doesn't work. Manually removing the single quote in front of the date fields has been the only thing that has worked, but I need to be able to do this in code. Does anyone have a solution for me? Thank you, Judy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Single Record to Append to Access Table | Excel Discussion (Misc queries) | |||
Export Access to Excel text field with numbers | Excel Discussion (Misc queries) | |||
Remove single quote | Excel Worksheet Functions | |||
Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) | |||
Quote qualified data export | Excel Programming |