The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

custom formatting

custom formatting

0
Votes
1
Answer

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 Answer

365 Team
0
Votes

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

×
Complete Data Science Training
Save 60%