Excel cell formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting up an excel workbook where information on the front page feeds
into the subsequent pages, like a questionnaire. Sometimes dates will be
entered in the first page but not always. I now find that if I do enter a
date at first and then delete it and enter another number (not a date) the
cell automatically reverts to the date format!!! Is there anyway I can stop
this happening? It is very frustrating.
Thanks
 
That is default, you can't change that. If this is info only you can
preformat as text and it will not format as date
 
Don't delete.

Use Edit>Clear>All

ALT + e,a,a


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Default number format in Excel 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Cell Format 1
conditional format cells by date 2
How do I stop Excel from copying date format from cell above? 2
Auto Cell Format Change from General to Custom Date 1
Formats Not Saving 1
Conditional formatting in Excel 2010 2

Back
Top