| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating
I have a long list of dates example.
01/15/2007 03/13/2007 04/04/2007 04/09/2007 04/09/2007 that I would like to format into a shorter date format. For some reason when I apply the new format it doesn't take until I click into each and every cell. Problem is I have a couple thousand. Thanks in adavance for the help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating
It looks like your data is in a column. If this is so, use
Tools Text to Columns to change the format -- Gary''s Student - gsnu200744 "Tony" wrote: I have a long list of dates example. 01/15/2007 03/13/2007 04/04/2007 04/09/2007 04/09/2007 that I would like to format into a shorter date format. For some reason when I apply the new format it doesn't take until I click into each and every cell. Problem is I have a couple thousand. Thanks in adavance for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If, Then, Or formating | Excel Discussion (Misc queries) | |||
| Help with formating | Excel Discussion (Misc queries) | |||
| Formating | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Formating h:mm AM/PM | Excel Discussion (Misc queries) | |||
Hybrid Mode
