Forum Discussion
How to hide leading single quotes
I use Azure Resource Graph to export data, for example:
tag
1-08
To prevent auto-convert, so I add a single quote to every rows:
tag
'1-08
Then I download the data as csv, and save as xlsx.
If I want to hide leading single quote, I have to double click the single cell. But there are many many cells in file, how I can hide for them?
I tried this, I got 1-08 in xlsx file. However after I double click the cell, and click out the cell, the value becomes to 8-Jan
TBH I really don't understand the purpose of doing this... Anyway, once you've imported the CSV with Get & Transform and have the result (Table) in Excel > Select the tag column > Format cells as Text ==> From now on, even if you double click a cell, and click out the cell the Text value will remain
Don't add any single quote. Export/Download your data as CSV > Import the CSV to Excel with Get & Transform and when you get the following window:
Click Transform Data (not
Load) at the bottom. This will open the Power Query Editor where you'll get something like:Delete the Changed Type step > Close & Load (top left of the Editor)
Result in Excel:
- I tried this, I got 1-08 in xlsx file. However after I double click the cell, and click out the cell, the value becomes to 8-Jan.
I used to want to find some global option to disable this auto-convert feature, but I may need send the file to others, the option may not configured in other's computer.I tried this, I got 1-08 in xlsx file. However after I double click the cell, and click out the cell, the value becomes to 8-Jan
TBH I really don't understand the purpose of doing this... Anyway, once you've imported the CSV with Get & Transform and have the result (Table) in Excel > Select the tag column > Format cells as Text ==> From now on, even if you double click a cell, and click out the cell the Text value will remain
