Note: The other languages of the website are Google-translated. Back to English
English English
  Saturday, 23 July 2022
  1 Replies
  2.4K Visits
0
Votes
Undo
Please, I nedd to format many cells through EXCEL like this: 000.000.000, how can I do ?
Thanks !
4 months ago
·
#2921
0
Votes
Undo
Hi there,

Is "." in the 000.000.000 a thousand separator? If so, you can select the cells where you want to apply the number format "000.000.000", and then press Ctrl + 1. On the Number tab, click Custom, and then type 000.000.000 in the Type box.
format cells.png

Then click OK.

The cells should now have the number format as you want.

Amanda
Attachments (1)
  • Page :
  • 1
There are no replies made for this post yet.
 
Copyright © 2009 - www.extendoffice.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL