When we enter a date with points, is there a possibility to convert it automatically into a date with slashes, so that it could be taken into consideration as a date ?
There is two solution, with a formula like this :
Or select the celles containing the date to modify, Menu > Home > Search and select > replace . by /
Note: Commissions may be earned from the links above.
This page contains references to products from one or more of our advertisers. We may receive compensation when you click on links to those products. For an explanation of our advertising policy, please visit this page.