At 02:04 28/12/2009 -0200, Pedro Izecksohn wrote:
[]calc does not understand any Date pasted as DDMMAA even though it
is able to represent =TODAY() using this format.
As so often, Paste Special is your friend. Instead of using ordinary Paste:
o Go to Edit | Paste Special... (or right-click | Paste Special...
or Ctrl+Shift+V).
o In the Paste Special dialogue, select "Unformatted text".
o In the Text Import dialogue, click in the relevant column to select it.
o For "Column type", select "Date (DMY)".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
