View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rossella
 
Posts: n/a
Default Date format problem

try this..

=CONCATENATE(STRING.extract(F7;7;2);"/";STRING.extract(F7;5;2);"/";STRINg.extract(F7;1;4))

f7 is where you've put 20060330

I don't know if the function names are right since I use excel in
Italian