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
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.- You're welcome & Thanks for providing feedback. Nice day...