Having trouble inputting numbers past 09 it shows 0.10 in excel

S

scary

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??
 
F

FSt1

hi
on the menu bar,...
tools>options>edit tab>uncheck fixed decimal places

Regards
FSt1
 
B

Bernie Deitrick

Scary,

Tools / Option... Edit tab, un-check fixed decimals.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel converted numbers to dates suddenly in All Sheets!!!! 3
Excel Formatting 1
Match Function Problem - Won't Find Certain Numbers 2
Excel text to numbers 1
retaining fonts when placing excel worksheet into pagemaker? 1
Stop excel changing the value of numbers in european formt 7
Keep numbers as entered with trailing zeros 2
Excel date formatting 1

Top