| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date field is held as 38932 how do I export as 3rd August 06
I am building up SQL statements using data in a Spreadsheet. I'm doing this
via CONCATENATE. I have a date field that appears to be 3rd August 2006 but in the concatenate appears as 38932. How do I get it to come through as 3rd August 2006? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need held for auto date calculation for adding years and substract | New Users to Excel | |||
| New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
| export .CSV with field containing double quotes? | Excel Discussion (Misc queries) | |||
| export excel data to a field in a pdf. | Excel Programming | |||
| VBA, How to open a file with date like 29 August 2004 | Excel Programming | |||
Threaded Mode
