At 15:15 19/01/2016 -0500, Alek Solzhenitsyn wrote:
On 01/19/2016 11:36 AM, Spencer Graves wrote:
You need Format > Cells > Numbers: Format code = 0000
With this, 0.1 appears as "0000" and 0.6 as "0001".
That isn't what I want- the wrong answer.
No, it *is* what you want. Once you have multiplied by 10000, your
values will (presumably) have no fractional parts, so the rounding
described as above, though accurate, will not be relevant. *Original*
figures of 0.1000 and 0.6000 will appear, when multiplied, as 1000
and 6000; it's only original figures of 0.00001 and 0.00006 (if they
existed) that would appear, rounded, as 0000 and 0001.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
