Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have one spreadsheet in Google Docs with data like:

0012
0234
0065

I wanna paste in another Google Doc Spreadsheet but when I use ctrl+c ctrl+v the data is formatted like numbers:

12
234
65

I want conserve the string format.

With right-click copy-paste I can't copy between spreadsheets.

Tested in Firefox and Chromium.

share|improve this question
1  
Very strange... Edit>Copy and Edit>Paste do not actually copy/paste anything between spreadsheets! Yet the keyboard shortcuts Ctrl+C and Ctrl+V (which are allocated to these menu items) do copy the values, but lose all formatting! –  w3d Aug 24 '12 at 10:15

3 Answers 3

up vote 2 down vote accepted

Place a single quote (') in front of the zeros before you copy the cells.

If you need to apply this to lots of cells, set the contents of one cell to ' and use CONCAT to populate a new column with the ' and the cell contents.

If A1 is ' and the values you want to copy start in B1:

Set C1 to =CONCAT($A$1, $B1) and fill the formula down.

share|improve this answer

The only workaround I see: press ' before pasting. It will preserve string format.

Pasting in the same spreadsheet preserves formatting. Pasting into another, says Pasting from web clipboard...

share|improve this answer
  1. copy the cells using Ctrl+C

  2. go to the target spreadsheet

  3. highlight the cells you want to paste them on

  4. go to FORMAT > NUMBERS > and click PLAIN TEXT at the bottom (this formats the cells to text fields before you paste)

  5. paste using Ctrl+V on the cells

share|improve this answer
1  
This don't work, neither Firefox nor Chromium –  Andrés Ricardo Torres Martínez Oct 26 '12 at 14:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.