Stop Excel Changing Format

  • Thread starter Thread starter Chris762
  • Start date Start date
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?
 
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.
 
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
Date Format 2
How do I calculate age using a 12 digit social security number in MS Excel? 0
How to enter a date in DD-MM-YYYY format 2
DATE FORMAT NOT WORKING 5
How to Convert 24/03/2010 as text into 03/24/2010 date format 2
Format for making date calculations 4

Back
Top