Or maybe it even needs to be backwards, given the fact it gives you 1.jan and
not jan.1...

To find out, try 1.2:

- if it returns 1.feb, then to retrieve the value, use:
=--(DAY(A1)&","&MONTH(A1))

- if it returns 2.jan, then use the first one I gave you:
=--(MONTH(A1)&","&DAY(A1))

"FiluDlidu" wrote:

Of course I meant:

=--(MONTH(A1)&","&DAY(A1))

(changed the dot for a comma, to fit your settings...)

"FiluDlidu" wrote:

Go in the control panel of your computer and edit your regional settings to
fit what you want them to be is what I would recommend (if your short date
settings are m.d.y, then typing 1.1 will indeed be interpreted as a date by
Excel).

Else, you can set a formula that would take your 39448 and transform it into
1,1 (assuming your 1.1 or 1.jan or 39448 is in cell A1):
=--(MONTH(A1)&"."&DAY(A1))

"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)