how do I enter a number so that it doesn't convert into a date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write seom results for a practicle, and I want to write numbers
such as 12-13, but what can I do so that they don't convert into dates such
as 13th of dec?? I tried to look around for a button that would stop thif
from happenening, but I'm not sure if there even is one!
 
Either preformat the cells as TEXT or precede the entries with an apostrophe
'. The apostrophe will not be displayed in the cell.

'12-13

Biff
 
Raquel

Pre-format the cells to Text or precede the 12-13 with an apostrophe, which
won't be visible in the cell.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

2 dimensional date sort 1
Turning numbers into Dates 4
Count the number of dates less than a given date 1
Skipping weekends during a count 1
The death of music TV channels in UK - but not Europe? 4
names dates & amounts stated multiple times in document 0
How do i convert dates to text but keep the date format 1
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 3

Back
Top