Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 2nd 08, 09:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,814
Default Fixed Decimal QHelp

I am using and learning Excel 2003. I checked fixed decimals and checked two
decimals in the options box of the tools menu. The fix word then appears in
the lower right hand corner of the screen. The following is my problem: I was
taught that by putting a period after a whole number and hitting enter the
number will be added to the cell as a whole number and not with a two decimal
entry. Example being...input 1009. into a cell and then press enter. The
result in the cell should be 1009 but I keep getting 10.09 . I thought that
by putting the period after the whole number indicates that the entry will be
the whole number and not a decimal entry. I haven't changed anything else
on my computer or the Excel program. It seems that the fixed decimal function
is not recognizing the period that I place after the whole number.
Any help would be greatly appreciated.
Thanks, Steve


  #2   Report Post  
Old December 3rd 08, 04:08 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Fixed Decimal QHelp

Hi,

With Fixed and 2 stet, I can't duplicate your problem, if I type 12 I get
0.12. If I type 12. I get 12.

Check your regional settings, is your decimal separator . or ,? Look under
Tools, Options, International and check Use system separators. Then check
windows defaults and see what Windows is using.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Steve" wrote:

I am using and learning Excel 2003. I checked fixed decimals and checked two
decimals in the options box of the tools menu. The fix word then appears in
the lower right hand corner of the screen. The following is my problem: I was
taught that by putting a period after a whole number and hitting enter the
number will be added to the cell as a whole number and not with a two decimal
entry. Example being...input 1009. into a cell and then press enter. The
result in the cell should be 1009 but I keep getting 10.09 . I thought that
by putting the period after the whole number indicates that the entry will be
the whole number and not a decimal entry. I haven't changed anything else
on my computer or the Excel program. It seems that the fixed decimal function
is not recognizing the period that I place after the whole number.
Any help would be greatly appreciated.
Thanks, Steve

  #3   Report Post  
Old December 3rd 08, 07:24 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 15
Default Fixed Decimal QHelp

Steve are you sure you are entering ' 1009. ' I know that if you omit the
period the number will be ' 10.09 ' in the cell.
--
Carrie


"Steve" wrote:

I am using and learning Excel 2003. I checked fixed decimals and checked two
decimals in the options box of the tools menu. The fix word then appears in
the lower right hand corner of the screen. The following is my problem: I was
taught that by putting a period after a whole number and hitting enter the
number will be added to the cell as a whole number and not with a two decimal
entry. Example being...input 1009. into a cell and then press enter. The
result in the cell should be 1009 but I keep getting 10.09 . I thought that
by putting the period after the whole number indicates that the entry will be
the whole number and not a decimal entry. I haven't changed anything else
on my computer or the Excel program. It seems that the fixed decimal function
is not recognizing the period that I place after the whole number.
Any help would be greatly appreciated.
Thanks, Steve



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
Help with fixed decimal Steve Excel Discussion (Misc queries) 4 December 2nd 08 07:31 PM
Fixed Decimal LoisTO Excel Worksheet Functions 2 March 20th 07 05:20 PM
Fixed Decimal Question Carla Excel Discussion (Misc queries) 12 January 5th 07 05:09 AM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM
Fixed decimal place CheriFireFox Setting up and Configuration of Excel 2 May 13th 05 04:10 PM


All times are GMT +1. The time now is 12:29 AM.

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