numbers displayed wrong

  • Thread starter Thread starter Richard van Rijsbergen
  • Start date Start date
R

Richard van Rijsbergen

When i type for example 22 in my excel sheet it is displayed as 0,22
This is also when i open a new empty sheet/workbook.
 
It works. Thnx

Bob Phillips said:
Goto Tools>Options>Edit and uncheck Fixed Decimal Places

--
__________________________________
HTH

Bob
Click to expand...
 
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

Using offset in sumproduct, is it possible? 2
Formula Audit mode active in one column only; cannot kill. 2
Merge Multiple workbook sheets into one workbook 0
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel Move or Copy Stopped Working? 0
Excel 2003 Formula Error 2
slow screen build-up 1
How to Display 12.5 but not 25.0 (drop .0’s) 5

Back
Top