| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change date format.
Thanks Dave. It worked
-- "Dave F" wrote: You need a custom format, not a function. Basically, you do the following: select the cells which you want to apply this format to, right click, select format cells, select custom format, and format your data DDMMYYYY You may want to test this on a backup copy of your data to insure that it's returning what you expect it to. Dave -- Brevity is the soul of wit. "Betmck" wrote: I have an excel 2003 file with 1500 dates in one column . The format is 10/31/2006 I have to import these dates into Microsoft Dynamics 9.0-fixed assets. To import, the date format should be 10312006. Is there a function that could strip the '/' out? could someone assist me with this task. Thanks -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the date format in Excell from eg 20060926 | Excel Discussion (Misc queries) | |||
| change date format | Excel Worksheet Functions | |||
| I cannot change the date format to English canada | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| change date function format in footer | Excel Worksheet Functions | |||
Hybrid Mode
