Numbers change into date.
 

I have excel 2003 and am doing a project for my school in it. The problem is
that every time I write something like 18,4 it changes into 18.apr. It only
happens in some rows in one of my Sheets so i guess it's something to do with
the settings. Because of this i cant finish my homework, but i don't want to
loose everything.

Numbers change into date.
 

Begin by typing an apostrophe (single quote):

'18,4
--
Gary''s Student - gsnu200779


"MarteinnS" wrote:

I have excel 2003 and am doing a project for my school in it. The problem is
that every time I write something like 18,4 it changes into 18.apr. It only
happens in some rows in one of my Sheets so i guess it's something to do with
the settings. Because of this i cant finish my homework, but i don't want to
loose everything.

Numbers change into date.
 

By doing that I cant use the number with calculations like sum ect. Is there
no settings i need to turn off for this to stop? I mean, I am sure you are
supposed to be able to write 18,2 or any other number in excel without it
turning into some kind of date.

"Gary''s Student" wrote:

Begin by typing an apostrophe (single quote):

'18,4
--
Gary''s Student - gsnu200779

Numbers change into date.
 

I found out what was wrong. I right clicked on the rows, then format cells,
then numbers, and set it to general settings.
"MarteinnS" wrote:

I have excel 2003 and am doing a project for my school in it. The problem is
that every time I write something like 18,4 it changes into 18.apr. It only
happens in some rows in one of my Sheets so i guess it's something to do with
the settings. Because of this i cant finish my homework, but i don't want to
loose everything.