Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert american dates from a query
Hi,
I checked past post about date conversions but couldn't find any that fix my problem: - I am doing a query that returns dates (text strings) in the format 1 Dec 2005, and I need to convert them to the user short date format. Problem is that the xl of those users does not understand "Dec". As there are "built in" functions that only works in the American format I was expecting this was going to be an easy one... but so far no success. Ideas Mika |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
convert american dates from a query | Excel Programming | |||
How do I convert spreadsheet from Canadian $ to American $? | Excel Discussion (Misc queries) | |||
English and American dates... | Excel Programming |