| 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) | |||
![Lisa[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
