Excel cell formats

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
 
P

Peo Sjoblom

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
 

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

Formats Not Saving 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How do I stop Excel from copying date format from cell above? 2
DATE FORMATS 4
Date 1
Default number format in Excel 1
Date 2
Stop XL from changing format? 1

Top