SOLVED

How to hide leading single quotes

Copper Contributor

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?

 

5 Replies

@XinlongMiche 

 

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:

Sample.png

Click Transform Data (not Load) at the bottom. This will open the Power Query Editor where you'll get something like:

Sample2.png

Delete the Changed Type step > Close & Load (top left of the Editor)

 

Result in Excel:

Sample3.png

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.
best response confirmed by XinlongMiche (Copper Contributor)
Solution

@XinlongMiche 

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

I tried "Select the tag column > Format cells as Text" and it works.
Thank you for your time, I think it's a acceptable answer.
You're welcome & Thanks for providing feedback. Nice day...
1 best response

Accepted Solutions
best response confirmed by XinlongMiche (Copper Contributor)
Solution

@XinlongMiche 

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

View solution in original post