Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole numbers showing as a decimal
I am not sure why, but everytime I enter a whole number such a 2 it show up
as 0.02 I have tried to format the cells in every which way possible. I have removed all of the decimals and then is just shows a 0. I have changed it from text to number and back again. The only way to make 2 show as 2 is for me to type in 2.0 or 2. , why is this happening? Better yet, how do I fix it? -- Lisa M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole numbers showing as a decimal
Tools/ Options/ Edit, and uncheck "Fixed decimal Places".
-- David Biddulph "Lisa" wrote in message ... I am not sure why, but everytime I enter a whole number such a 2 it show up as 0.02 I have tried to format the cells in every which way possible. I have removed all of the decimals and then is just shows a 0. I have changed it from text to number and back again. The only way to make 2 show as 2 is for me to type in 2.0 or 2. , why is this happening? Better yet, how do I fix it? -- Lisa M. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole numbers showing as a decimal
Go to menu, Tools|Options, Edit tab, and uncheck the box for Fixed Decimal.
-- ** John C ** "Lisa" wrote: I am not sure why, but everytime I enter a whole number such a 2 it show up as 0.02 I have tried to format the cells in every which way possible. I have removed all of the decimals and then is just shows a 0. I have changed it from text to number and back again. The only way to make 2 show as 2 is for me to type in 2.0 or 2. , why is this happening? Better yet, how do I fix it? -- Lisa M. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole numbers showing as a decimal
You are the best. That was sooo simple. I should have asked you months ago.
-- Lisa M. "David Biddulph" wrote: Tools/ Options/ Edit, and uncheck "Fixed decimal Places". -- David Biddulph "Lisa" wrote in message ... I am not sure why, but everytime I enter a whole number such a 2 it show up as 0.02 I have tried to format the cells in every which way possible. I have removed all of the decimals and then is just shows a 0. I have changed it from text to number and back again. The only way to make 2 show as 2 is for me to type in 2.0 or 2. , why is this happening? Better yet, how do I fix it? -- Lisa M. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole numbers showing as a decimal
You are the best. That was sooo simple. I should have asked you months ago.
-- Lisa M. "John C" wrote: Go to menu, Tools|Options, Edit tab, and uncheck the box for Fixed Decimal. -- ** John C ** "Lisa" wrote: I am not sure why, but everytime I enter a whole number such a 2 it show up as 0.02 I have tried to format the cells in every which way possible. I have removed all of the decimals and then is just shows a 0. I have changed it from text to number and back again. The only way to make 2 show as 2 is for me to type in 2.0 or 2. , why is this happening? Better yet, how do I fix it? -- Lisa M. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole numbers showing as a decimal
FANTASTICi was struggling with this too!!!
"John C" wrote: Go to menu, Tools|Options, Edit tab, and uncheck the box for Fixed Decimal. -- ** John C ** "Lisa" wrote: I am not sure why, but everytime I enter a whole number such a 2 it show up as 0.02 I have tried to format the cells in every which way possible. I have removed all of the decimals and then is just shows a 0. I have changed it from text to number and back again. The only way to make 2 show as 2 is for me to type in 2.0 or 2. , why is this happening? Better yet, how do I fix it? -- Lisa M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Why is a cell formatted as a zip code is showing up as a decimal? | Excel Discussion (Misc queries) | |||
How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
Extra 1 showing up in 15th decimal place | Excel Discussion (Misc queries) |