At 09:17 10/04/2008 +0100, João Pinto wrote:
I would like to know if anyone can help me with
a capacity problem that i have found in openoffice calc.
So, i want to convert in my work some
Hexadecimal serials numbers, but calc only
supports 15 digits as processed numbers, is ti
possible to increase up to 20 or 25?
It would be very helpful.
Do you need to perform calculations with these
numbers? If not, you can simply enter them as
text. Either format the cells as text before you
enter the data, or else precede the numbers with
an apostrophe to force Calc to interpret them as
text rather than as numbers. In fact, most
hexadecimal numbers would be seen by Calc as text
anyway (since they will contain the letters A to F), wouldn't they?
If you need to perform calculations with such
high-precision numbers, I suspect the only
workaround is to split them into parts, perhaps
putting the first ten and the last ten digits in
separate cells. You would then have to create
complicated formulae to do whatever calculations
you needed based on the separate parts of the
data. It sounds complicated but it is
possible. Calc won't do calculations in base 16 anyway, will it?
I'm sending one attachment as an example of i would like to do if possible.
The mailing list processor normally removes
attached files from messages before distributing
them - and did so in your case. So no-one will have seen your attachment.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
