Hi David, this is not how oocalc works, just use '=A4' to refere to another cell.
"=TEXT(<cell>,<format>)" converts a number into text using the given format (also in Excel btw.). Markus ** Changed in: openoffice.org (Ubuntu) Status: New => Invalid -- =TEXT() formula doesnt work https://bugs.launchpad.net/bugs/178514 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs