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

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" <(E-Mail Removed)> wrote in message news:CC414541-A1DF-4A13-BDBA-(E-Mail Removed)...
> 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

hi
tools>Options>edit tab>uncheck 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

First guess would be Tools>Options>Edit>Fixed 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 <(E-Mail Removed)>
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