Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with fixed decimal
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. Any help would be greatly appreciated. Thanks, Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with fixed decimal
Steve,
That is indeed how it is supposed to work, and how it actually works for me. Do you have any event code that would change the entry value? A lot of folks use the change event to handle decimal points. HTH, Bernie MS Excel MVP "Steve" wrote in message ... 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. Any help would be greatly appreciated. Thanks, Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with fixed decimal
Yes. Decimal point after the number should (and does for me) over-ride the
fixed decimals. Do you have a macro or an auto-correction option that is upsetting things? Do your regional settings look for a period or for a comma as the decimal point? -- David Biddulph "Steve" wrote in message ... 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. Any help would be greatly appreciated. Thanks, Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with fixed decimal
Bernie,
Thanks for the quick response. Not sure what you mean by an event code. 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. Steve "Bernie Deitrick" wrote: Steve, That is indeed how it is supposed to work, and how it actually works for me. Do you have any event code that would change the entry value? A lot of folks use the change event to handle decimal points. HTH, Bernie MS Excel MVP "Steve" wrote in message ... 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. Any help would be greatly appreciated. Thanks, Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with fixed decimal
David,
Thanks for the reply. How would I know if I have a Macro or auto-correct option that might be doing this? I tried inputing the number 1009 with a comma after it and it entered it into the cell as "1009," left hand registered. For some reason it is not recognizing the period I place after the whole number. Steve "David Biddulph" wrote: Yes. Decimal point after the number should (and does for me) over-ride the fixed decimals. Do you have a macro or an auto-correction option that is upsetting things? Do your regional settings look for a period or for a comma as the decimal point? -- David Biddulph "Steve" wrote in message ... 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. Any help would be greatly appreciated. Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixed Decimal | Excel Worksheet Functions | |||
Format Numbers Without Fixed Decimal | New Users to Excel | |||
Fixed Decimal Question | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Fixed decimal place | Setting up and Configuration of Excel |