I have a Bubble app that outputs values into different columns and exports report as a csv…
I was facing the problem where values like 50 would not convert into $50.00 on the spread sheet. then I found this online.
It works but first you must go to Format–>cells and convert to currency and then use the advice above to make the dollar values stick.
If you know a easier way please let me know.