0

When I copy numbers using either "Edit/Copy" or "Crtl+C" in Google Sheets on PC and then use "Edit/Paste/Special/Paste Values" or (Crtl+shift+V), the numbers are indeed pasted. They appear normal and are in the formula entry box as numbers, but they are not treated as numbers in GRAPHING.

The only way I can see that they are not "normal" is that they are Left aligned instead of Right aligned. By the way, the prior FORMAT of the cell doesn't change this behavior, but formatting the cell with the numbers in it can be used with FORMAT\NUMBER\"0.0" to make them normal.

I am otherwise either using "Format/Number/Automatic" or "Format/Number/"0.0"

This odd "invisible formatting survives copy pasting and EDIT\PASTE SPECIAL\ PASTE TRANSPOSED.

1

Try CTRL + SHIFT + V followed by CTRL + \.

This should reset the formatting from whatever back to Automatic.

0

Or use straight this combo:

  1. CTRL + SHIFT + V
  2. LEFT ALT + O
  3. N
  4. N
  • @BenjaminWade answer updated – user0 Jul 13 at 4:07
  • 1
    Thank you for the suggestion. I tried the first method to no effect. Pasted values remained abnormal and unrecognized as numbers, and left aligned, which showed that something was wrong with them. Your second suggestion works well, as a shortcut way of formatting them correctly. Thanks again. – Benjamin Wade Jul 13 at 4:13
  • While I appreciate the answer, and it somewhat addresses the problem, it requires a manual process and (I mean no disrespect) doesn't address the underlying problem. I will accept the answer later if I can't find any other way of addressing this issue. I am attempting to automate the process and I can't be reforting manually all the time. I do appreciate the answer however. – Benjamin Wade Jul 13 at 4:29
  • @BenjaminWade you are welcome – user0 Jul 13 at 4:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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