I have a small spread sheet with a date column, and each day I enter data. My format is 23-11-23 and tomorrow 24-11-23 and so on. When I get the cross at the bottom right of the latest date cell it will not input the next date.
I have no idea what is wrong? Ideas please?
B2
[Solved] Dragging dates in column
[Solved] Dragging dates in column
Last edited by MrProgrammer on Tue Dec 12, 2023 5:10 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]; Dates must be numbers (blue) if you want Autofill to increment them -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved]; Dates must be numbers (blue) if you want Autofill to increment them -- MrProgrammer, forum moderator
Apache OpenOffice 4 on Windows 7
Re: Dragging dates in column
Start by /View /Value Highlighting and check your data types. Black is text, blue a number, green a formula,
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Dragging dates in column
- Attachments
-
- dates.ods
- (12.79 KiB) Downloaded 51 times
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