How do I change Excel default number?

P

PatrickR

Recently upgrade to Excel 2007. When I type in 125000 and press enter key it
changes to 12.5 and when I type in 5000 it gives me 0.5 My question is how
do I change to setup so that what ever I typed in it stay that way? Thank
you for your help in advance.
 
N

Niek Otten

Office button (large round, top left)>Excel Options>Advanced tab>Uncheck
"Automatically insert a decimal point"
 

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

VBA word change keys 0
Paragraph numbering in Word 1
Excel does not accept text format! 0
how can i change a sequence of numbers using find replace 2
Cross-reference Insert Default Change 0
How do I set focus (and select text) on a text box on a modeless userform? 0
WORD VBA Search and switch to advanced ... 1
New computer, how do i move outlook 365 ENTIRELY? 0

Top