| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Have Excel format xxxxxx into date format
I've looked all over the place and can't find this anywhere. We just want to
type numbers such as 020406 and have Excel format as 02/04/06. Can anyone help please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Have Excel format xxxxxx into date format
Chip Pearson has some code that may help you:
http://cpearson.com/excel/DateTimeEntry.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Teri wrote: I've looked all over the place and can't find this anywhere. We just want to type numbers such as 020406 and have Excel format as 02/04/06. Can anyone help please? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Have Excel format xxxxxx into date format
Thanks for your reply, Dave. When I copy and paste the formula at Chip's
site, it doesn't work. "Dave Peterson" wrote: Chip Pearson has some code that may help you: http://cpearson.com/excel/DateTimeEntry.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Teri wrote: I've looked all over the place and can't find this anywhere. We just want to type numbers such as 020406 and have Excel format as 02/04/06. Can anyone help please? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Have Excel format xxxxxx into date format
Those are macros.
You'll want to read David McRitchie's intro. Teri wrote: Thanks for your reply, Dave. When I copy and paste the formula at Chip's site, it doesn't work. "Dave Peterson" wrote: Chip Pearson has some code that may help you: http://cpearson.com/excel/DateTimeEntry.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Teri wrote: I've looked all over the place and can't find this anywhere. We just want to type numbers such as 020406 and have Excel format as 02/04/06. Can anyone help please? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, want to change date format from us to uk, for old data. | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Linear Mode
