| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
| number format keeps dividing by 100 | New Users to Excel | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
