Stop decimal points in EXCEL.......

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I stop my spreadsheet from putting in decimal points?

I keep trying to type in numbers and all it wants to do is put in a decimal
point.
 
Do you have the cells formatted as NUMBER with a set number of decimal
places?

Or, check this setting:

Tools>Options>Edit>Fixed decimal places

Biff
 
You must log in or register to reply here.

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

Decimal point in general format 1
Convert Decimal fractions to binary and vice versa 1
problem with number format with 2 decimals? 5
excel 2003 zero as last decimal 5
Addition errors with Decimal Places 5
Two digit number with one decimal, or three digit number 2
Display a digit before or after the decimal point in another cell 7
Access stripping decimal places in query 1

Back
Top