custom formatting
how to make the # in ( custom formatting, number) refer to 3 digits rather than just one, so the number in my table in excel will be separated as thousands?
1 answers ( 0 marked as helpful)
Hi Robin,
I'll be happy to help. Could you try with the following format:
#,##0.0,
This is if you want to display the number in thousands in Excel.
Best,
Ned