Modify date

Hello,

Im using excel 2010.
i have a cell with the following data 20150101
how can i make the date look better?

Thanks

If the text/number in cell A1 try this formula

Hi,
An alternative try:

=RIGHT(A1,2)&"."&MID(A1,5,2)&"."&LEFT(A1,4)

=RIGHT(A1,2)&"-"&MID(A1,5,2)&"-"&LEFT(A1,4)

=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)

Thanks guys,

well its not in A1unfortunately

kobiv said:

well its not in A1unfortunately

Click to expand...

So good. Can and in G17

navic said:

So good. Can and in G17

Click to expand...

actually i start typing and got distracted so... anyway got that. still no magic.

THANKS FOLKS

You can convert this number into real Excel dates (in fact, if you have a column of dates like this you can convert them all at once):
Select the numbers you want to convert (only a single column at a time), then in the Data part of the ribbon, find Text to Columns in the Data Tools section, and click it.
In Step 1 of the dialogue box, choose Delimited, click Next, in step 2 remove all ticks from all boxes, click Next.
In step 3 choose Date then choose YMD in the dropdown, click Finish.
Now you have real dates, you can format them as you wish.