Stopping automatic change to date format

  • Thread starter Thread starter Matthew McManus
  • Start date Start date
M

Matthew McManus

I need to retain entries such as "1-7" in General format. Excel
automatically changes it to 1-July.

Any ideas about stopping this?

Thanks
Matthew
 
Hi
- enter a leading apostrophe. e.g. '1-7
- You may change the format to 'Text' prior to entering values

Frank
 
While the previous replies are good, they change the format away from
date format and can no longer be used with other functions (like tryin
to find elapsed time between two dates). If you want to keep the cel
formatted as a date go to format/cells and select the number tab
Scroll down to "Custom" and in the "Type:" field type in:

d-m

This will format the day (1) a dash and then the month (7). Now whe
you type "1-7" into the cell, it will stay as 1-7, but will retain th
date format and can be used in other functions.

Note: you must have your regional options in control panel set to rea
the day-month
 

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

Defaulting to date format 4
Remove date format? 3
stop dates format automatically excel 2002 4
Auto Cell Format Change from General to Custom Date 1
yearfrac format error? 4
Stopping automatic change to date format 2
Excel Vba to change displayed year automatically. 14
Stop XL from changing format? 1

Back
Top