| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why can't I convert Long date format to Short date
Hi,
I recently received a report filled with dates in Long Date format (Friday, January 22, 2010). I would like to convert these dates into Short date format but Excel will not let me. I don't know if this is a bug within Excel. I have tried both Excel 2003 and 2007 with the same problem. My regional settings is set to English (United States). I am not sure what I am doing wrong? It doesn't seem that Excel allows the use of the long date field even though you can take a short date and convert it to long date but not the other way around. Can someone please tell me if this is a limitation within Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why can't I convert Long date format to Short date
Jason,
Are you sure it's a properly formatted date? It may be text. Try adding 1 to it and see if it increases by 1 day -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jason" wrote: Hi, I recently received a report filled with dates in Long Date format (Friday, January 22, 2010). I would like to convert these dates into Short date format but Excel will not let me. I don't know if this is a bug within Excel. I have tried both Excel 2003 and 2007 with the same problem. My regional settings is set to English (United States). I am not sure what I am doing wrong? It doesn't seem that Excel allows the use of the long date field even though you can take a short date and convert it to long date but not the other way around. Can someone please tell me if this is a limitation within Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert US date with 12hr format to European date 24hr | Excel Discussion (Misc queries) | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Storing data in Short Date format | New Users to Excel | |||
| OFC 07 wrkbk saved short date format changes to general when reop | Excel Discussion (Misc queries) | |||
| short date format not working while i try to excel afte | Excel Discussion (Misc queries) | |||
Linear Mode
