ExcelBanter - date in text format as a real date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - date in text format as a real date (https://www.excelbanter.com/excel-worksheet-functions/167334-date-text-format-real-date.html)

Mortir

date in text format as a real date

I have a date that is in text format 12.01.08 (dd.mm.yy). However I
cant convert it to a real date which can be used for further
operations. The format cell - date does not work... Thanks for your
help

Mike H

date in text format as a real date

Try

Select your date then

data|text to columns
Select fixed width
Next
Next
Select date D/M/Y
Finish

Mike

"Mortir" wrote:

I have a date that is in text format 12.01.08 (dd.mm.yy). However I
cant convert it to a real date which can be used for further
operations. The format cell - date does not work... Thanks for your
help

Gord Dibben

date in text format as a real date

DataText to ColumnsNextNextColumn Data FormatDateDMY and Finish.

Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 04:26:06 -0800 (PST), Mortir wrote:

I have a date that is in text format 12.01.08 (dd.mm.yy). However I
cant convert it to a real date which can be used for further
operations. The format cell - date does not work... Thanks for your
help

All times are GMT +1. The time now is 01:27 PM.