Cor Nouws wrote:
2. Changing and existing Cell's Number Formatting to Text. Would be
better if the result was that what ever was visible previously was
now in the cell. e.g. if I have a date displayed in a cell, changing
the format to Text results in a number in the cell, whilst for the
purposes of calculatulation having a date stored as a number is
useful, it serves no useful purpose to display this number to the
user. Also the Undo feature dould not reverse this. Fortuanlty I had
a saved version.
You mean: a cell has letts say 30-04-07 and you change format to text,
and the cell stil shows 30-04-07? What then would be the use of changing
format to text?
No. What he means is if the cell shows 30-04-07 formatted as a date and
you change the cell format to text it now shows "39202", which is the
internal integer Calc uses for that date.
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
