Thread: format colum for identity number and next colum age
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default format colum for identity number and next colum age
Assuming a string of numbers in cell A1, use the following formula.
D1: =MID(A1,1,6) & " " & MID(A1,7,4) & " " & MID(A1,11,2) & " " &
MID(A1,13,1)
E1: =INT(INT(TODAY()-DATE(1900+MID(A1,1,2),MID(A1,3,2),MID(A1,5,2)))/
365.25)
You may need to modify the formats.

Hth,
Merjet
Reply With QuoteReply With Quote