Excel problem - letter "D" always appears in dates

S

Silentio

I'm experiencing a very weird problem with Excel.

Whenever I enter a date--be it short or long-form--the letter d
appears. So March 03, 2010 appears as 03d03d2010 or even as March d,
2010.

Not sure what is going on.

Can anyone explain it?
 
V

Victor Delta

Silentio said:
I'm experiencing a very weird problem with Excel.

Whenever I enter a date--be it short or long-form--the letter d
appears. So March 03, 2010 appears as 03d03d2010 or even as March d,
2010.

Not sure what is going on.

Can anyone explain it?

If you click on such a cell and go to Format, Cells... and select the Number
tab, has a custom format been set for dates perhaps?

V
 
S

Silentio

If you click on such a cell and go to Format, Cells... and select the Number
tab, has a custom format been set for dates perhaps?

V

It hadn't. But the problem suddenly stopped. Can't explain why...
maybe memory but that seems odd to me. Hopefully, it's gone for good.
BUt thanks for your response.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top