Yep.

11/10 looks way too much like a date.

=11/10
should work ok, too.

Or just 1.1
<vbg

MarteinnS wrote:

Thanks! I changed the windows date format to slash. And it is working now.
Pre-Format didn't work as the list i used updates from a website.
1,1 was working fine. it was just 1.1 (one-dot-one).
In addition, Now i can't write 11/10 but =SUM(11/10) works. That's what i
wanted, thanks!

"Dave Peterson" wrote:

It sounds like your windows format for the short date is using the dot
character. This is pretty unusual. I'd use the control panel to change this
character to a slash or hyphen.

But if you don't want to change this setting, you could preformat the cell as
text, then do the data entry or start with an apostrophe: '1.1

But if you don't change this setting, don't you have trouble typing 1.1 (=11/10)
when you want a real number?

MarteinnS wrote:

I cant write 1.1 in Excel 2003. Always when I do that it changes to "1.jan"
Then when i try to format the cell to general, number or anything else it
changes to 39448.
Please tell me how i can write 1.1 in excel without it changing into 39448
or tell me how i can delete date formats out of Excel so I can use it.......
I am using a list of numbers that update automatically from a website, but
it gives all the values out as "1.1" or "11.3" or something like that but
they all change into dates which changes into random date-formated numbers I
cant use.

Also, if anyone knows. How Can I change 1.1 to 1,1(a number i can use for
calculations)

--

Dave Peterson


--

Dave Peterson