When you type a date into OpenOffice.org's Calc program, it automatically recognises and formats it as a date. When you try to copy and paste this date in another cell, this formatting goes along with it. Formatting these cells as text after pasting is too late, because it will convert it into the internal date number which Calc uses when calculating dates. To paste a date as text, you must copy the actual data, and paste it into pre-formatted cells.
- Skill level:
Other People Are Reading
Open your spreadsheet in OpenOffice.org.
Right-click the cell where you plan to paste the date, and select "Format Cells."
Click "Numbers" tab in the "Format Cells" window.
Click "Text" in the "Category" list, and click "OK."
Click the cell that contains the date you wish to copy.
Click and drag your mouse over the date in the top "Input Line" to select it. The "Input Line" is located immediately above the column letters.
Hold the "Ctrl" key, and press "C" simultaneously to copy the date.
Click the cell you previously formatted.
Hold the "Ctrl" key and press "V" simultaneously to paste the date as text in that cell.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for