| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format
I need to format or change the way my date values are entered in Excel.
Currently they are 4/9/2009 - I need them to be 04092009. I created a custom format however when I import them into Access still reads those at 04/09/2009. I need them to show up as 04092009 in the cell as well as in the formula bar. Even when I get the correct format and I do copy paste special values it appeared to divide them. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
If you are not doing math on the dates, then you can just enter a text string
representing your date, by preceeding the entry with an apostrophe, or formatting the cells as TEXT, then enter 04092009 and it will stay that way..... Vaya con Dios, Chuck, CABGx3 "Erika" wrote: I need to format or change the way my date values are entered in Excel. Currently they are 4/9/2009 - I need them to be 04092009. I created a custom format however when I import them into Access still reads those at 04/09/2009. I need them to show up as 04092009 in the cell as well as in the formula bar. Even when I get the correct format and I do copy paste special values it appeared to divide them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
