Thread: Date Format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSHAWARDHAN. S .SHASTRI[_2_] HARSHAWARDHAN. S .SHASTRI[_2_] is offline
external usenet poster
 
Posts: 69
Default Date Format

As your original data is in text format , pl use following formula.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
HARSHAWARDHAN.S.SHASTRI

Pl do not forget to press "YES" button if post found useful.


"aozora" wrote:

Hi all,
I have the column of date in general/text format as "20080402", how can i
change it into date format, is there any format to change directly?
Thanks a lot