Automatic data conversion in Excel
 

When I enter or import data into Excel, 30/150 becomes 30/150, but 2/24
becomes Feb 01, 2024. How to prevent excel from interpereting the data wrong
way?
--
:-)

enter
'2/24

--
Regards,
Tom Ogilvy


"Dejan" wrote in message
...
When I enter or import data into Excel, 30/150 becomes 30/150, but 2/24
becomes Feb 01, 2024. How to prevent excel from interpereting the data
wrong
way?
--
:-)

Thank you Tom, it works for key entry.

Is it possible to prevent Excel from 'thinking' for me? Is there some
setting to tell Excel NOT TO understand 1/19 as January 19, 2005?

:-)


"Tom Ogilvy" wrote:

enter
'2/24

--
Regards,
Tom Ogilvy


"Dejan" wrote in message
...
When I enter or import data into Excel, 30/150 becomes 30/150, but 2/24
becomes Feb 01, 2024. How to prevent excel from interpereting the data
wrong
way?
--
:-)