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 Answer 1

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
4
  • @BenjaminWade answer updated
    – user0
    Jul 13, 2019 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. Jul 13, 2019 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. Jul 13, 2019 at 4:29
  • @BenjaminWade you are welcome
    – user0
    Jul 13, 2019 at 4:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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