Change Date Format

**artiststevens** · 02-17-2012, 06:57 AM

Hello,
Could anyone help me to change the format of the date below? I tried date format but it didn't work. I believe I need a formula for this.

From: 2000.11.05

To: 11/5/2000

Thanking you in advance for any and all help.

**Domski** · 02-17-2012, 07:00 AM

Try using Text To Columns and at the 3rd step specify the date format.

Dom

**artiststevens** · 02-17-2012, 10:00 PM

Hey Domski. Thanks for the help. I tried using text to columns but it isn't working for me. Any other suggestions. Thanks again.

**bebo021999** · 02-17-2012, 11:20 PM

Try this:
=--SUBSTITUTE(A1,".","/")
Hope it works

**artiststevens** · 02-18-2012, 12:19 AM

Thank you Bebo! That worked like a charm!

**RBPrice** · 02-19-2012, 03:02 PM

I would like the date printed in the header to read day month year. Is there a way to force that to happen?

Thanks a bunch.

**Domski** · 02-20-2012, 06:12 AM

Please take a moment to read the forum rules.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Dom