Forum Discussion
Formatting a number so it has a comma in the thousands place
I did all this hard work to get the percentage and number together in my graph, but now I can't figure out how to get a comma in there so it reads 325,451. My formula so far is: =C38&CHAR(10)&" ("&TEXT(D38,"0%")&")"
C38 is the cell that contains the value "325,451"
I have been having this issue as well and have found a hacky solution. It seems that when you initiate the camera in Zoom, it stops it from working in Teams. The only way to get it working again in Teams is:
1) Reboot into Mac
2) Download/Open Teams app on Mac
3) Initiate camera (either start a video call or test camera in Teams > Settings > Devices)
4) Reboot into Windows and the camera on Teams should be working again.
HOWEVER as soon as you start the camera on Zoom again (also seems to happen with Google Meet), it will stop working on Teams and you will have to repeat the process above.
It seems using the camera on Zoom/Google Meet causes the camera to become incompatible with Teams (and also Skype). Hopefully an actual fix to this is coming soon
2 Replies
- StoneKiwiIron Contributor
> Right click the cell
> click Format Cells...
> Select this options and Click OK
Or to reference the cell and have it display text then
=TEXT(cell,"##,#0")