Maybe an App Script solution to format that column every time that Sheet has an update.
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.
Ah… that is another story!
Text() function always returns a text value 
wow, thank you @gvalero! 
Thank you for your link @ThinhDinh. Finally, I found the samples of relevant app script → Set cell format with google apps script - Stack Overflow