Excell date formating

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
 
N

Niek Otten

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: [email protected]
 
F

Frank Kabel

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
 
Top