Ask Your Question

Column format not adhered to

asked 2018-01-16 05:42:42 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have the format of two columns of a spreadsheet set to "Number General" and up to now it has been displaying correctly. However, when I opened the spreadsheet today, it was displaying both columns in date format (e.g. instead of "97" it shows "06/04/00" and the tooltip shows the correct value of "97"). When I open the "format cells" dialog, the highlighted category and format is still "Numbers/General" as I would have originally set it. It appears that the only way to correct this was to set the format to something else and then reset it back to the correct category and format. Does anyone have any idea what could have caused this?

edit retag flag offensive close merge delete


Please attach a sample file if you still have it. Also, do not post as community wiki. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-16 23:32:14 +0200 )edit

If it is a number, then why not format as Number -1235 (format code 0) for example? That would fix the issue for sure. General may do any number of things. Having said that, without more information, I do not know why the problem occurred.

Jim K gravatar imageJim K ( 2018-01-16 23:35:28 +0200 )edit

No sample available - as I indicated, the format was still showing as 'Numbers/General" and I reset it to something else before resetting it to "Numbers/General" again, and I didn't think to save the earlier version.

and - - Sorry!! I didn't intentionally check the "community wiki" checkbox (can it be unchecked?).

jimberry gravatar imagejimberry ( 2018-01-18 09:31:37 +0200 )edit

"Can it be unchecked" - it doesn't look like it. That leaves either posting the question again or else simply remembering not to check the box for future questions.

Jim K gravatar imageJim K ( 2018-01-18 20:05:27 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-17 16:23:49 +0200

erAck gravatar image

If number format is General and a date is displayed it may be that there is conditional formatting applied which style includes a date format. Check menu Format -> Conditional Formatting -> Manage...

edit flag offensive delete link more


The only conditional formatting was related to background colour.

jimberry gravatar imagejimberry ( 2018-01-18 09:34:13 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-16 05:42:42 +0200

Seen: 30 times

Last updated: Jan 17 '18