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