Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Why does format column to date insert apostrophe? '08/03/2015

Why does format column to date insert apostrophe? '08/03/2015 I wanted to apply a different date format, performed the function properly through format cells with column highlighted. No apostrophe existed in the column cells before this and was verified trying other formats. After the function was performed, apostrophe appeared disabling the selected cells from following the date format requested. Once I go through every cell and delete the apostrophe, the cells happily conform to the specified date format. Help?

Windows 10 Pro, LibreOffice Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99 Locale: en_US

Why does format column to date insert apostrophe? '08/03/2015

Why does format column to date insert apostrophe? '08/03/2015 I wanted to apply a different date format, performed the function properly through format cells with column highlighted. No apostrophe existed in the column cells before this and was verified trying other formats. After the function was performed, apostrophe appeared disabling the selected cells from following the date format requested. Once I go through every cell and delete the apostrophe, the cells happily conform to the specified date format. Help?

Windows 10 Pro, LibreOffice Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99 Locale: en_US

Why does format column to date insert apostrophe? '08/03/2015

Why does format column to date insert apostrophe? '08/03/2015 I wanted to apply a different date format, performed the function properly through format cells with column highlighted. No apostrophe existed in the column cells before this and was verified trying other formats. After the function was performed, apostrophe appeared disabling the selected cells from following the date format requested. Once I go through every cell and delete the apostrophe, the cells happily conform to the specified date format. Help?

Windows 10 Pro, LibreOffice Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99 Locale: en_US