Forum Discussion
How to hide leading single quotes
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
- 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.
