>> []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.
This would help if I would paste a column at once. But my specific case is that I need to paste date by date, that is cell by cell, as each date comes from a different html shown by some browser, which may be Firefox or IE. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org