change data in cell

**riccja** · 06-15-2009, 04:48 PM

How would you convert the date below to the other format

20060520

to

5/20/06

Rick

**shg** · 06-15-2009, 04:51 PM

Welcome to the forum.

=TEXT(A1, "0000\/00\/00") + 0

... and format as you wish.

**NBVC** · 06-15-2009, 04:56 PM

Or select column and go to Data|Text to Column.... skip to 3rd window, select Date and YMD from Drop down...

Click Finish.

**riccja** · 06-15-2009, 05:04 PM

Thanks...

I put that in the column next to the first number and then get #VALUE! in the cell

I have a column of dates in the first number format ie 20060520

I need to get the dates in the 05/20/06 format for all the cells.

Since I am new at using formulas i need a simple step by step approach

any help would be appreciated

Rick

**riccja** · 06-15-2009, 05:08 PM

just saw your 2nd response ..that did it...

Thanks!

Rick

**NBVC** · 06-15-2009, 05:13 PM

Please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save