Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index


As Johnny says, we probably need more information to help. #VALUE
normally means that the number is too big to fit in the space it is
allowed. You should be able to see the value by selecting the cell and
looking at the contents in the display above the top of the sheet. Or
make the cell bigger, or reduce the font size :)

The formula was fine. But I'm guessing the text wasn't. I retyped and it worked. Might have been an unprintable character or a misplaced bit. I've run into this before with various versions of cut 'n paste but none that I've solved in this context.


Chris Johnson
Ex SysAdmin, now, writer /One does not get better but different and older and that is always a pleasure./
(Gertrude Stein)

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.