Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 30th 06, 02:41 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2
Default 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   Report Post  
Old August 30th 06, 05:45 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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 half-way 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   Report Post  
Old August 30th 06, 10:11 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2
Default 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 half-way 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   Report Post  
Old August 31st 06, 12:16 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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 half-way 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   Report Post  
Old August 31st 06, 02:03 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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 half-way 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling Data off Web - Need Function Help patfergie44 Excel Worksheet Functions 9 June 22nd 06 03:27 AM
how to input a 12 digit number into a cell jedi New Users to Excel 11 June 19th 06 08:26 PM
How do I insert 2 decimal places to a number in cell? Rebecca Martinez Excel Worksheet Functions 6 July 7th 05 07:12 PM
How do i stop automatic decimals after number ex 5280.? Frustrated Excel Discussion (Misc queries) 1 March 17th 05 12:47 AM
spread the number 123.45 so each digit goes to a different cell Linda H. Excel Worksheet Functions 6 February 17th 05 07:07 PM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017