View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Totti Totti is offline
external usenet poster
 
Posts: 51
Default getting date in special form

Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated