New installed Excel2003 keeps dividing any number entered in any .
 

I do have a new installation of Excel2003 Small Business Edition. When I
create a blank document or use a old spreadsheet, it keeps dividing any
number entered in any cell by 100 unless I ad a comma and a digit after the
comma

Tools / Options / Edit Tab / Untick 'Fiexd Decimal places'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jan E. Sørensen" <Jan E. wrote in
message ...
I do have a new installation of Excel2003 Small Business Edition. When I
create a blank document or use a old spreadsheet, it keeps dividing any
number entered in any cell by 100 unless I ad a comma and a digit after
the
comma

That did the trick!
Thank you!!!

"Jan E. Sørensen" wrote:

I do have a new installation of Excel2003 Small Business Edition. When I
create a blank document or use a old spreadsheet, it keeps dividing any
number entered in any cell by 100 unless I ad a comma and a digit after the
comma

You're welcome :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jan E. Sørensen" wrote in message
...
That did the trick!
Thank you!!!

"Jan E. Sørensen" wrote:

I do have a new installation of Excel2003 Small Business Edition. When I
create a blank document or use a old spreadsheet, it keeps dividing any
number entered in any cell by 100 unless I ad a comma and a digit after
the
comma