How to Paste a Date as Text in OpenOffice Calc

Written by c. taylor
  • Share
  • Tweet
  • Share
  • Email

When you type a date into'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:


  1. 1

    Open your spreadsheet in

  2. 2

    Right-click the cell where you plan to paste the date, and select "Format Cells."

  3. 3

    Click "Numbers" tab in the "Format Cells" window.

  4. 4

    Click "Text" in the "Category" list, and click "OK."

  5. 5

    Click the cell that contains the date you wish to copy.

  6. 6

    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.

  7. 7

    Hold the "Ctrl" key, and press "C" simultaneously to copy the date.

  8. 8

    Click the cell you previously formatted.

  9. 9

    Hold the "Ctrl" key and press "V" simultaneously to paste the date as text in that cell.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.