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

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

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

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

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