Stop Excel Changing Format

C

Chris762

In Excel I want to just show a date as dd/mm in a cell. Every time I enter
this Excel shows the number in dd/mm/yy format, even when I change the cell
to use the General format. Any idea how I get Excel to show the number as I
want?
 
F

Fred Smith

What you want to enter is not a date (to Excel). It's two numbers separated
by a slash. So your choices are:

1. Precede your entry with an apostrophe (')
2. Preformat your cells as Text.

Regards,
Fred.
 
R

Rob van Gelder

With General Format, Excel just does what it wants.

In the same list as "General", choose a date format, or a custom format like dd/mm

Cheers,
Rob
 

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

Change date format in Excel footer 2
can I change the date format as dd-mm-yy 7
How do I calculate age using a 12 digit social security number in MS Excel? 0
Date Format 2
Extracting just the time portion 5
How to enter a date in DD-MM-YYYY format 2
converting dd/mm/yy to mm/dd/yyyy 3
Compare dates (re-stated) 1

Top