11-5678 turned into Nov-78?

Thread view:

Thread rating:

newuserex - 19 Oct 2004 18:07 GMT

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 - 19 Oct 2004 18:23 GMT

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

Regards,

Peo Sjoblom

> 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!

Bernie Deitrick - 19 Oct 2004 18:35 GMT

Or format for mm-yyyy ;-)

HTH,
Bernie
MS Excel MVP

> Precede entry with ' (apostrophe) or pre format as text
>
> > I tried to format the cell with a custom format 00-0000. It won't help.