How do I change the date format?

  • Thread starter Thread starter ILoveMyCorgi
  • Start date Start date
I

ILoveMyCorgi

If anyone could help, I would be appreciative... I have 800 rows of data
where the date is currently formatted:

1. YYYYMMDD How do I change this to MM/DD/YYYY?

2. Telephone number is currently formatted as 7607236300. How do I change
this to 760-723-6300?

Thank you for helping me.
 
#1.
Select the column with the dates
Data|text to columns (xl2003 menus)
Choose Fixed widths, but don't include any separator lines.
Choose Date (ymd order)
and finish up.

Change the number format (format|cells|number tab) to the format you want
(mm/dd/yyyy).

#2. Select the range to fix
Change the number format to Custom: 000-000-0000
 
1. YYYYMMDD How do I change this to MM/DD/YYYY?
Select the Column and do
RightClick>>FormatCells>>Number>>Category>>Custom>>Type>> Paste the below
formulat
mm/dd/yyyy
and give Ok.

2. Telephone number is currently formatted as 7607236300. How do I change
this to 760-723-6300?
Select the Column and do
RightClick>>FormatCells>>Number>>Category>>Custom>>Type>> Paste the below
formulat
###-###-####
and give Ok.

Remember to Click Yes, if this post helps!
 
If the values in the date column are really dates (just formatted as YYYYMMDD),
then your first suggestion will work.

If the values are plain old numbers (like 20100217), then this suggestion won't
work. The values need to be converted to dates.
 
Back
Top