Stopping automatic change to date format

  • Thread starter Matthew McManus
  • 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
 
F

Frank Kabel

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

Frank
 
M

MrBridge

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

Remove date format? 3
Stopping automatic change to date format 2
How to remove the automatic date format? 3
Auto Cell Format Change from General to Custom Date 1
Defaulting to date format 4
dd/mm/yy if i change to some other format 2
Date Issue 2
Disable auto (date) format? 3

Top