Timeline for In Excel, how to treat values starting with = as text and not a formula?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 29, 2021 at 20:06 | vote | accept | Topher Rhodes | ||
| Apr 29, 2021 at 20:04 | comment | added | Topher Rhodes | @ScottCraner I tried to do that using the following steps: Click on the column heading to select entire column. Click Format > Cells. Click the Number tab. Select “Text” from the Category list. Click OK. But it did not work, I still have #NAME? in those cells (when click the cell I see the value in the entry field, but it's #NAME? when saved as CSV) | |
| Apr 29, 2021 at 20:02 | comment | added | Topher Rhodes | @spikey_richie I can, but when I export the data as a CSV the ' is there and as ' appear elsewhere in the data I'm not sure how to remove them after. | |
| Apr 29, 2021 at 19:26 | answer | added | BradR | timeline score: 3 | |
| Apr 29, 2021 at 18:42 | comment | added | spikey_richie |
Can you not escape it using ' at the start of the line?
|
|
| Apr 29, 2021 at 18:34 | review | First posts | |||
| Apr 30, 2021 at 0:08 | |||||
| Apr 29, 2021 at 18:32 | comment | added | Scott Craner | you can set the column in which they are put to Text. | |
| Apr 29, 2021 at 18:30 | history | asked | Topher Rhodes | CC BY-SA 4.0 |