Decimal Point Placement
 

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

Decimal Point Placement
 

Try this:

From the Excel Main Menu:
<tools<options<edit tab...UNcheck: Fixed Decimal Places

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Scott" wrote in message ...
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

Decimal Point Placement
 

hi
toolsOptionsedit tabuncheck fixed decimal Places

not sure how that will effect a protected sheet. personally i have never run
into that but it should work for all other sheets.

Regards
FSt1

"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

Decimal Point Placement
 

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