How do I change the date format?


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.
 
Ad

Advertisements

D

Dave Peterson

#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
 
M

Ms-Exl-Learner

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!
 
Ad

Advertisements

D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top