Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Since yesterday if I enter a whole number in a cell, for example 123, when I
leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Format-Cells-Number
Change it to General or Number, whatever you like -- Please remember to indicate when the post is answered so others can benefit from it later. "kg_ce" wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Thanks for your quick reply but it did not change the problem... It's driving
me crazy!!! "KC Rippstein" wrote: Format-Cells-Number Change it to General or Number, whatever you like -- Please remember to indicate when the post is answered so others can benefit from it later. "kg_ce" wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
ToolsOptionsEdit. Uncheck "fixed decimal places"
Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Thank you, thank you, thank you!!!
"Gord Dibben" wrote: ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
You made my day!!! Now let's see if you can also help me on this one:
I have this number in a cell 12.29 I need to divide it by 30 and multiply it by 365 so I type =(d24*30/365) I get the result 1,0100000000 If I do the same operation on a calculator the result is 0,0101369863 Is there some way I can get the same result with Excel??? "Gord Dibben" wrote: ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
The result I get is 1.0101369863 in Excel
I think you have a typo in your post in this 0,0101369863 If the 12.29 value is actually 12.288333333 formatted to 2 DP I get 1.0100000000 Gord On Sat, 3 Mar 2007 10:28:00 -0800, kg_ce wrote: You made my day!!! Now let's see if you can also help me on this one: I have this number in a cell 12.29 I need to divide it by 30 and multiply it by 365 so I type =(d24*30/365) I get the result 1,0100000000 If I do the same operation on a calculator the result is 0,0101369863 Is there some way I can get the same result with Excel??? "Gord Dibben" wrote: ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Oooops, you're right!!! It is 1.0101000000. Thanks again!!!
"Gord Dibben" wrote: The result I get is 1.0101369863 in Excel I think you have a typo in your post in this 0,0101369863 If the 12.29 value is actually 12.288333333 formatted to 2 DP I get 1.0100000000 Gord On Sat, 3 Mar 2007 10:28:00 -0800, kg_ce wrote: You made my day!!! Now let's see if you can also help me on this one: I have this number in a cell 12.29 I need to divide it by 30 and multiply it by 365 so I type =(d24*30/365) I get the result 1,0100000000 If I do the same operation on a calculator the result is 0,0101369863 Is there some way I can get the same result with Excel??? "Gord Dibben" wrote: ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Yes, thank you from me too. Every time I typed in a whole number I ended up
with 2 decimal places, and not being very computer literate was having a tough time of it. I did well to find this site. Cheers, Vonne "Gord Dibben" wrote: ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
col of minus numbers changed to plus numbers | Excel Worksheet Functions | |||
Run formula only if values are enter, otherwise leave blank | Excel Worksheet Functions | |||
when i enter time in cell it changed, why? | Excel Worksheet Functions | |||
Why does date come up when I enter numbers in cell/Excel? | Excel Discussion (Misc queries) | |||
How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) |