Ask Your Question

How to stop calc changing text to date when pasting

asked 2017-10-23 14:22:58 +0200

grahamh gravatar image

Copying and pasting a table from Base to Calc, where I have data like '10/02' but it's not a date. How do I stop Calc changing it to 10/02/17?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-10-23 14:33:19 +0200

JohnSUN gravatar image

It is here

Date acceptance patterns

edit flag offensive delete link more


Language - who'd have thought?

grahamh gravatar imagegrahamh ( 2017-10-23 14:56:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-23 14:22:58 +0200

Seen: 91 times

Last updated: Oct 23 '17