Yeah... but it doesn't matter if I write e.g. 3.5 or 3-5 or 3/5.... the
result is always March 5th.... Some auto conversion is done. And I would like
it switched off... Do you have any idea?

"Dave Peterson" wrote:

You sure that it isn't August 1st, 1934 (or 2034)??? Try formatting that cell
in an unambiguous format (mmmm dd, yyyy) and you'll see for sure what it is.

It looks like your windows regional setting for the date separator is a dot.
You may want to change it something else--I use a slash (/).



AkelA wrote:

I tried to enter the following data into my Excel 2003:

34.08 1,813.94 1,882.09
207.33 4,175.63 4,590.29
284.25 5,019.79 5,588.29
0.00 296.97 296.97
5.03 30.17 40.23

And the result was:

aug.34 1,813.94 1,882.09
207.33 4,175.63 4,590.29
284.25 5,019.79 5,588.29
0.00 296.97 296.97
03.máj 30.17 40.23

Why is Excel converting my data into dates? And 34th August? You must be
kidding!

--

Dave Peterson