I type 19 - shows up in cell as .19

T

Trev.

I have tried changing the formatting but that is not the problem (I
don't think). The problem is that somehow a decimal is being entered
that I do not want without me hitting the decimal button. Please help
 
J

John McGimpsey

I have tried changing the formatting but that is not the problem (I
don't think). The problem is that somehow a decimal is being entered
that I do not want without me hitting the decimal button. Please help
Click to expand...

Preferences/Edit... uncheck the Fixed decimal places checkbox.
 

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 does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Anchor issue with inserting a shape for letterhead 1
Need Help with a VBA subroutine 0
Scroll does not show preview 0
Word doc keeps changing to ALL CAPS 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Converting decimal degrees to degrees, minutes & seconds 2

Top