worksheet formats

  • Thread starter Thread starter hems
  • Start date Start date
H

hems

All figures entered are being displayed as decimals
despite fomatting them to whole numbers
 
Hi hems,
If you mean that Excel is changing numbers entered without
a decimal point to something else like changing 123
to 1.23 or .0123 or 12300 then that would be the
fixed decimal input feature most useful to accountants.

Tools, Options, Edit (Tab), remove checkmark by Fixed Decimals

There are two items when you use Format, Cells, Number
one is thousands separator, and the other is the number
of decimal places.
 

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


Back
Top