Why does my format keep changing in the cell?

D

Denise

I keep having issues with excel and it is always the same. I will be working
in a sheet and in the same column but different row and all of a sudden it
changes my format from general to a date format. I then go to edit and clear
contents and it resets to general and as soon as I go back to the cell and
enter the number and hit tab it resets to the date format again. This also
happens to my date formatting as well. I want it to be in one date format
and it keeps changing it to a different date format. I should be able to
type in aug10 and get my format selection of 08/10/2005 but it shows up as
Oct.-08.
 

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