Automatic data conversion in Excel

D

Dejan

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?
 
D

Dejan

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?

:)
 
Top