Dividing All My Spreadsheet Entries By 10

  • Thread starter Thread starter David Howells
  • Start date Start date
D

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.
 
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.
 
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
 
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




.
Click to expand...
 
Back
Top