Automatic change when inserting data

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

When I enter a new value into a cell, it changes
automatically to 1/10th of my value. I have General format of
the cell. Is there any Registry item, where it is set?
 
Hi

Tools.Options.Edit - uncheck FixedDecimalPlaces


Arvi Laanemets
 
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

Numbers change in cell even when formatted as text 4
Conditional formatting in Excel 2010 2
Varied accuracy custom number formats 3
Cannot choose Additional Values when editing in Select Data of a c 1
Data being corrupted by excels automatic date recognition re-forma 6
cell automatically changing format 2
CSV->Excel Data Problem 1
Auto Cell Format Change from General to Custom Date 1

Back
Top