Formatting cells. 2 becomes 0,02.

B

Bob Greenblatt

I type 2 and excel show 0.02. Why? I can't find out how to change the
formatting
Click to expand...
Look in preferences. For the Edit options, uncheck Fixed 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

Decimal problem 8
Table Preferred width is changed when pasting 1
Excel does not accept text format! 0
Changing Monthly Data to Daily Data? 1
Inconsistent formatting of section numbers 0
Images are pixelated when saving to PDF 0
Outlook 365 overriding formatting choices 0
Cell data entering slow! 0

Top