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?
--
:-)
|