Hi guys I used open office to open an excel spreadsheet that I've written before. I was pretty impressed that the vlookups worked well, but I've encountered a little bit of a problem.
I have a cell (E5) which has the following: ="+"&SUM(C5+D5). What it does in excel is to add the values of the cell which are '+2 and '+1 respectively. What it looks like in excel from a print point of view is +2 +1 +3 I had a look through the open office help, but wasn't able to see any solutions. I suspect I'm just using the wrong syntax. Any help would be appreciated, Rob T ************************************************************* This mail, including any attached files may contain confidential and privileged information for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended receipient (or authorised to receive information for the recipient), please contact the sender by reply e-mail and delete all copies of this message. ************************************************************* -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
