Maybe an App Script solution to format that column every time that Sheet has an update.
1 Like
1 Like
Does that keep the underlying data as a number? If that’s a yes then it will be the solution. I’m not sure how @IDEApps will use this and why it still needs to be a number under the hood.
1 Like
Ah… that is another story!
Text() function always returns a text value 
2 Likes
wow, thank you @gvalero! 
1 Like
Thank you for your link @ThinhDinh. Finally, I found the samples of relevant app script → Set cell format with google apps script - Stack Overflow
3 Likes