ExcelBanter - Formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formating (https://www.excelbanter.com/excel-discussion-misc-queries/158323-formating.html)

tony

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.

Gary''s Student

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.

All times are GMT +1. The time now is 07:07 PM.