Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers change to Date error | Excel Discussion (Misc queries) | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
change numbers to date | New Users to Excel | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions |