How do I stop Numbers adding quotation marks when copying cell contents
I am trying to generate some HTML from within Numbers. I cannot seem to copy and paste this results into any other ap because Numbers seems to be appending quotation marks
Here is my formula: =CHAR(8232)&CHAR(8232)&"<!-- ! "
When I see this in numbers I see two blank lines and the start of a HTML comment. OK so far.
When I copy this and paste as a value into another cell within Numbers. this is what I get. OK ... but not that useful for me.
When I copy and paste from numbers to any other app ... then the quotation marks are appended.
If I remove the newline characters then there is no quotations appended ... only when the cell contains a new line do I see the quotation marks. Arrrgh!!!
When I copy a range of cells from numbers, some with new lines ... some without, the quotation marks are appended to each cell containing new lines .. but not those cells without the new lines.
How do I s top this apparent consistent inconsistency!
Since Numbers does not allow char(10) (but is Excel compatible?) Is there another way to create blank lines through formulae where Numbers does not break anything!
Can anybody reproduce this? Is it a bug?
Thanks.