Hi,

Right click the cellFormatCustomin the "Type:" box type: m/d

Tim

"Janneman" wrote:

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!