Numbers change into date.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarteinnS - 14 Apr 2008 17:06 GMT

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.

Reply to this Message

Gary''s Student - 14 Apr 2008 18:25 GMT

Begin by typing an apostrophe (single quote):

'18,4

Signature

Gary''s Student - gsnu200779

> 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.

Reply to this Message

MarteinnS - 14 Apr 2008 19:35 GMT

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.

> Begin by typing an apostrophe (single quote):
>
> '18,4

Reply to this Message

MarteinnS - 14 Apr 2008 19:46 GMT

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

Reply to this Message