Numeric Data Entry problem

N

NukeTony

In a shared Excel spreadsheet, one users computer when he enters a number it
is displayed as the number divided by 100. So he enters 5, it is displayed
and recorded as 0.05. On my computer, I open the same file (shared) and
enter 5 in the same cell and it is displayed and entered as 5.
Any thoughts? I've worked with the format issue and the macros and have
found nothing that would cause this to occur.
 
P

Pete_UK

On your user's machine, click on Tools | Options | Edit tab and then
UNCHECK fixed decimal (about half-way down).

Hope this helps.

Pete
 
D

Dave Peterson

In xl2003 menus:

Tools|Options|Edit tab|Uncheck Fixed Decimals.

It's nice for the accountancy types who don't want to waste time typing decimal
points.
 

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

Data Entry Problem 3
Stop Excel from converting integers into decimals (eg.; 12 to .12) 1
User entry in cell creates popup 3
Excel won't resolve formula in one column 3
Numeric Format Changes From 1 Cell to the Next? 2
Create a yes no message on a command button on click 0
Possible to make certain cells default to 0? 6
Conditional formatting in Excel 2010 2

Top