Data Entry Problem

R

rqueneau

Very strange behavior just started. Even on a new spreadsheet, if I enter a
number in a cell, like the number 5, it's instantly diveied by 100 and the
cell contains 0.05. I work with a lot of engineering spreadsheets and they
all started doing this. I've tried formatting the cells to General, Number
(with no decimal places) and others, but it continues to happen. Ran Office
diagnostics but it came up with nothing. The problem is local to my laptop
only. I emailed a problem spreadsheet to my home system and tried it there.
Everything works fine. I enter 2, and the cell shows 2.

Has anyone seen this before and if so, what is the fix? Please help as this
is making my life miserable. Thanks.
 
F

FSt1

hi
you have fixed decimais in place.
2003-on the menu bar.....
tool>options>edit tab> uncheck fixed decimal places
2007
office button>excel options>not sure after this.
2007 expert - help

Regards
FSt1
 
S

Sheeloo

Excel 2007
office button>excel options>advanced
clear the check box '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

Numeric Data Entry problem 2
problem with fractions to decimal 1
Number Format Problem 2
problem with round down 5
Excel number entry 3
How do I prevent the cell from changing the number I enter? 2
Weird formula malfunction, has anyone seen this before? 2
How to Import data from a different .xls file 2

Top