Excell date formating

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I am trying to type numbers with dashes and slashes, but
excell always converts to date format, How do I stop this?

Thanks,
Doug
 
Hi Doug,

Precede with an apostrophe (single quote, '). It will cause Excel to treat
the enry as text and not show the apostrophe.
--
Kind regards,

Niek Otten
Alida de Jongstraat 7
2401 KS Alphen aan den Rijn
Netherlands
tel. +31-172-416 880
mobile: +31-6-518 62 541
e-mail: (e-mail address removed)
 
Hi
either format the cell prior to entering values as 'Text' (Format -
Cells)
or preced your entry with an apostrophe. e.g.
'12/12/01
 

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

Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
Date Format 2
Remove slash charaters from a date field 3
To enter a date 5
Can I enter a date without using the / or hyphen? 2
date input mask 1
Rewrite name in new format 4
Convert excel file to flat text file 1

Back
Top