What am I doing wrong? Thank you.
| Edit: Changed subject, was Can't format cells for date Make your post understandable by others -- MrProgrammer, forum moderator |
[Solved] 03/04/24 changed to ¾ 24 (fraction)
[Solved] 03/04/24 changed to ¾ 24 (fraction)
Ye Olde Luddite id back......I'm trying to add dates to my spreadsheet in this format 03/04/24 -- I go to "Format" then "Cell" and choose this format but when I write a date it winds up looking like a fraction -- for example 03/04/24 looks like 3/4 24 (three quarters, fraction style) -
What am I doing wrong? Thank you.
What am I doing wrong? Thank you.
Last edited by MrProgrammer on Sun Mar 03, 2024 9:40 pm, edited 1 time in total.
Windows 8 - Open Office 4.0.1
Re: Can't format cells for date
If you type exactly 03/04/24, including the zeros, do you get the fraction? I don't get that. If you want to type 3/4/24, I think you have to go to the menu Tools -> AutoCorrect Options, choose the Replace tab, and remove the entry for 3/4.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Can't format cells for date
Hello Sir,
I've seen for myself. Please find enclosed test file.
Regards
Nick
I've seen for myself. Please find enclosed test file.
Regards
Nick
- Attachments
-
- test date format.ods
- (11.59 KiB) Downloaded 29 times
Libre Office 6.0.7 on Ubuntu 18.04
Re: Can't format cells for date
Your column A uses the default locale, which is German(Germany) in my case and the dates are displayed like 31.12.99 here. If your default locale is English(UK), 31/12/99 might be the displayed date.
Column B uses English(USA) as locale with number format M/D/YY displayed with one or two digits for the month and day.
Column B uses English(USA) as locale with number format D. MMMM YYYY displayed with one or two digits for the day, 4 digit year and the full month name.
Column B uses English(USA) as locale with number format MM/YY displayed with two digits for the month and year.
All this formatting voodoo never changes any cell value. You can format your cells as number, currency, date, whatever. This has no effect on the cell value, nor derived calculation results.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Can't format cells for date
Wishful thanks Villeroy,
The word test was inappropriated.
Nick
The word test was inappropriated.
Nick
Libre Office 6.0.7 on Ubuntu 18.04