https://bugs.documentfoundation.org/show_bug.cgi?id=98081
Beluga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Beluga <[email protected]> --- I noticed the dates were formatted as Number by default. I formatted them as Date. When I started to edit them, I saw: '08/7/2009 I removed the ' and everything was ok. I searched and found this: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=22539&start=0 This fixed them: How to convert numeric text to number by re-entering everything in one step. Select the cells in question (col C). Apply Eng US Date format MM/DD/YYYY menu:Find&Replace... [More Options...] [X] Current Selection [X] Regular expression Search: .+ (a dot and a plus) Replace: & [Replace All] Now you have proper dates in the column. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
