View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janneman Janneman is offline
external usenet poster
 
Posts: 2
Default How can I write 3/5 in a cell and have it look like 03-May back?

Have tried to write in 3/5 and have it look like 03-May back, but excel
always comes back with 05-March! Have tried to format cells with both dates
and specials and also tried the "text to columns" but nothing works.
Anyone who can solve this problem?

Thanks!