Timeline for Google Sheets on PC Copy/paste using "Paste Values" (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 13, 2019 at 4:31 | comment | added | user0 | @BenjaminWade you are welcome | |
| Jul 13, 2019 at 4:29 | comment | added | Benjamin Wade | 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:13 | comment | added | Benjamin Wade | 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:07 | comment | added | user0 | @BenjaminWade answer updated | |
| Jul 13, 2019 at 4:07 | history | edited | user0 | CC BY-SA 4.0 | added 201 characters in body |
| Jul 13, 2019 at 3:32 | history | answered | user0 | CC BY-SA 4.0 |