[]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
scalc does not understand any Date pasted as DDMMAA even though it
is able to represent =TODAY() using this format.
Often I need to paste dates as Text and calculate days by head.
-
To unsubscribe, e-mail:
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 |