View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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