Home 
Search 
Today's Posts 
#1




How do I stop decimal being placed in a 3 digit whole number
On a new spread sheet, every time I try to type a 3 digit whole number or
less (i.e. 2 digits) the cell records the number with a decimal placed after the first number. How do I get the cell formated to accept whole numbers. If I chekc the , between numbers and the number I use in 4 digits or longer I do not have the problem. I have tried removing the decimal to 0. 
#2




How do I stop decimal being placed in a 3 digit whole number
Check out Tools  Options  Edit (tab) and look for Fixed Decimal
(about halfway down the panel)  you should ensure that this is unchecked, otherwise every time you enter a number it will be treated as having 2 decimal places (the default, which should be greyed out). Hope this helps. Pete Jhawk wrote: On a new spread sheet, every time I try to type a 3 digit whole number or less (i.e. 2 digits) the cell records the number with a decimal placed after the first number. How do I get the cell formated to accept whole numbers. If I chekc the , between numbers and the number I use in 4 digits or longer I do not have the problem. I have tried removing the decimal to 0. 
#3




How do I stop decimal being placed in a 3 digit whole number
Thanks very much for the response. I did exactly as you told me and that
fixed my problem immediately. I appreciate your response. Jhawk "Pete_UK" wrote: Check out Tools  Options  Edit (tab) and look for Fixed Decimal (about halfway down the panel)  you should ensure that this is unchecked, otherwise every time you enter a number it will be treated as having 2 decimal places (the default, which should be greyed out). Hope this helps. Pete Jhawk wrote: On a new spread sheet, every time I try to type a 3 digit whole number or less (i.e. 2 digits) the cell records the number with a decimal placed after the first number. How do I get the cell formated to accept whole numbers. If I chekc the , between numbers and the number I use in 4 digits or longer I do not have the problem. I have tried removing the decimal to 0. 
#4




How do I stop decimal being placed in a 3 digit whole number
Glad to help  thanks for feeding back.
The setting you had is useful if you have a lot of currency values to enter, eg dollars and cents or pounds and pence and you don't want to have to enter the decimal point each time  apart from that, it is better to avoid it. Pete Jhawk wrote: Thanks very much for the response. I did exactly as you told me and that fixed my problem immediately. I appreciate your response. Jhawk "Pete_UK" wrote: Check out Tools  Options  Edit (tab) and look for Fixed Decimal (about halfway down the panel)  you should ensure that this is unchecked, otherwise every time you enter a number it will be treated as having 2 decimal places (the default, which should be greyed out). Hope this helps. Pete Jhawk wrote: On a new spread sheet, every time I try to type a 3 digit whole number or less (i.e. 2 digits) the cell records the number with a decimal placed after the first number. How do I get the cell formated to accept whole numbers. If I chekc the , between numbers and the number I use in 4 digits or longer I do not have the problem. I have tried removing the decimal to 0. 
#5




How do I stop decimal being placed in a 3 digit whole number
The strange part is...........all numbers should have the 2 decimal places.
You state that 4 digit numbers or longer entered correctly. What's up with that? Gord Dibben MS Excel MVP On Wed, 30 Aug 2006 14:11:02 0700, Jhawk wrote: Thanks very much for the response. I did exactly as you told me and that fixed my problem immediately. I appreciate your response. Jhawk "Pete_UK" wrote: Check out Tools  Options  Edit (tab) and look for Fixed Decimal (about halfway down the panel)  you should ensure that this is unchecked, otherwise every time you enter a number it will be treated as having 2 decimal places (the default, which should be greyed out). Hope this helps. Pete Jhawk wrote: On a new spread sheet, every time I try to type a 3 digit whole number or less (i.e. 2 digits) the cell records the number with a decimal placed after the first number. How do I get the cell formated to accept whole numbers. If I chekc the , between numbers and the number I use in 4 digits or longer I do not have the problem. I have tried removing the decimal to 0. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Pulling Data off Web  Need Function Help  Excel Worksheet Functions  
how to input a 12 digit number into a cell  New Users to Excel  
How do I insert 2 decimal places to a number in cell?  Excel Worksheet Functions  
How do i stop automatic decimals after number ex 5280.?  Excel Discussion (Misc queries)  
spread the number 123.45 so each digit goes to a different cell  Excel Worksheet Functions 