First guess would be ToolsOptionsEditFixed Decimal Places is enabled but
can't see that because that is a global setting for Excel and would affect all
sheets and workbooks, including new ones.

So your mate would get same action with new sheets.

Any event code running behind the sheet?

Right-click on the sheet tab and "View Code"

Anything there?


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 16:32:00 -0700, Scott
wrote:

We are using Excel 2003 and a worksheet that is supplied and cells protected.
In certain cells we need to put a figure such as 1.5 however when we do this
it comes out as 115.0. Using the same spreadsheet on my PC it works
correctly - the problem is appearing on my workmate's PC. If he wants 1.5 to
appear he has to enter it as .0015. As the worksheet is protected we are
unable to simply change the formatting of the cell. It must have something
to do with the excel on his PC although when he opens a black worksheet he is
able to enter 1.5 as 1.5. Anyone got any ideas? Thanks