11-5678 turned into Nov-78?

[newuserex]

I tried to format the cell with a custom format 00-0000. It won't help.

Could you give me some help? Thanks a lot

 

[Peo Sjoblom]

Precede entry with ' (apostrophe) or pre format as text

Regards,

Peo Sjoblom

 

[Bernie Deitrick]

Or format for mm-yyyy ;-)

HTH,
Bernie
MS Excel MVP