| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having trouble inputting numbers past 09 it shows 0.10 in excel
I am having trouble with the numbers in excel when I enter 10,11 & 12 etc it
appears as 0.10, 0.11 & 0.12 I have used the format section and the numbers to try to change it but with no joy I have even been into the windows function for the settings but still cannot change it. Any Ideas?? -- scary says thanks you very much |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having trouble inputting numbers past 09 it shows 0.10 in excel
hi
on the menu bar,... toolsoptionsedit tabuncheck fixed decimal places Regards FSt1 "scary" wrote: I am having trouble with the numbers in excel when I enter 10,11 & 12 etc it appears as 0.10, 0.11 & 0.12 I have used the format section and the numbers to try to change it but with no joy I have even been into the windows function for the settings but still cannot change it. Any Ideas?? -- scary says thanks you very much |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having trouble inputting numbers past 09 it shows 0.10 in excel
Scary,
Tools / Option... Edit tab, un-check fixed decimals. HTH, Bernie MS Excel MVP "scary" wrote in message ... I am having trouble with the numbers in excel when I enter 10,11 & 12 etc it appears as 0.10, 0.11 & 0.12 I have used the format section and the numbers to try to change it but with no joy I have even been into the windows function for the settings but still cannot change it. Any Ideas?? -- scary says thanks you very much |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having trouble inputting numbers past 09 it shows 0.10 in exce
Hi thanks very much this worked.
Mark -- scary says thanks you very much "Bernie Deitrick" wrote: Scary, Tools / Option... Edit tab, un-check fixed decimals. HTH, Bernie MS Excel MVP "scary" wrote in message ... I am having trouble with the numbers in excel when I enter 10,11 & 12 etc it appears as 0.10, 0.11 & 0.12 I have used the format section and the numbers to try to change it but with no joy I have even been into the windows function for the settings but still cannot change it. Any Ideas?? -- scary says thanks you very much |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having trouble inputting numbers past 09 it shows 0.10 in exce
Hi,
This worked thank you very much, Mark -- scary says thanks you very much "FSt1" wrote: hi on the menu bar,... toolsoptionsedit tabuncheck fixed decimal places Regards FSt1 "scary" wrote: I am having trouble with the numbers in excel when I enter 10,11 & 12 etc it appears as 0.10, 0.11 & 0.12 I have used the format section and the numbers to try to change it but with no joy I have even been into the windows function for the settings but still cannot change it. Any Ideas?? -- scary says thanks you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting numbers using a macro. | Excel Discussion (Misc queries) | |||
| Date format shows on formula bar, 5 digit numbers show in row | Excel Discussion (Misc queries) | |||
| Formula to count numbers past a specified limit | Excel Worksheet Functions | |||
| Negative numbers shows up as )8.20( instead of (8.20) | Charts and Charting in Excel | |||
| How do I get rid of infinite numbers past the decimal place? | Excel Worksheet Functions | |||
Linear Mode
