Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You should set the cell format first and then enter the scores, or use "Paste special..." from the Edit menu and select to paste only the value.

If you copy and paste cells in Calc, you are not only copying the raw cell contents, but the contents and all the formatting, formulae, etc.

From your description I understand that you first enter data, then copy it, then change the cell format and finally paste the cell contents back in. This would copy and paste the value as a date, even if you change the cell format in between. The paste special feature lets you select what you want to paste.

Without knowing the goal of your spreadsheet (no pun intended) or your spreadsheet design, an alternative way of entering scores is to use two cells - one for either team. It may be easier to process.