ne laptop using libre office calc with windows 11 pro, I have a speadsheet were column A is the date going back 3 years, today I went to enter some data and although the setting is set correctly I am getting incorrect input, ie todays date should be 15th April 2023, (15/4/23) it omes out as a fraction, any help and advice to tell me what I am doing wrong will be appreciated
Please choose Tools - Options - Language Settings - Languages and make sure that in this field the date pattern actually contains the “slash” separator
thank you JonSUN, much appreciated
You are being hit by auto-correction while entering a 3/4 fraction (and no, it shouldn’t happen with 15/4). You can Ctrl+Z once immediately after such correction happened. Or you disable the auto-correction entirely under Tools → AutoCorrect Options…, tab Options, uncheck Use replacement table. Or delete just the 1/2, 1/4 and 3/4 replacements from the list in the Replace tab (enter 1 in the Replace edit field to jump to the entry). Note however that AutoCorrect Options apply to all LibreOffice modules, so if you want to continue to use these replacements in Writer rather switch Use replacement table on/off.
Also make sure the Date Acceptance Patterns are set correctly, what JohnSUN said, but as you seem to use the English (UK) locale, the patterns for you would be D/M/Y;D/M instead of the English (USA) M/D/Y;M/D
thank you erAck, all sorted, I appreciate your help and advice
