Dividing All My Spreadsheet Entries By 10

[David Howells]

Whenever I enter a figure into a cell in a spreadsheet it
automatically divides the number I enterd by 10. How do I
stop this please. I have tried re-installing and
tried "Detect and Repair" - any idesa please.

 

[Norman Harker]

Hi David!

Try:

Tools > Options > Edit
Remove check from "Fixed decimal places"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Nikos Yannacopoulos]

David,

Type 10 in a free cell, go Edit > Copy or Ctl+C, then select the area you
want to divide by 10 (or the whole sheet) and go Edit > Paste Special >
Divide. You're done.

HTH,
Nikos

 

[David Howells]

Many thanks

-----Original Message-----
David,

Type 10 in a free cell, go Edit > Copy or Ctl+C, then select the area you
want to divide by 10 (or the whole sheet) and go Edit > Paste Special >
Divide. You're done.

HTH,
Nikos




.