About # # separator.
Hi sir, In my worksheet, # # Separating the number 196647 as 19664 7. It is supposed to be formatted as 196 647, right?
Please feel free to share a screenshot of your workbook - the format you created and what you obtained - so I can understand better. Thanks!
If you want to use a space as a thousands separator for all numbers in Microsoft Excel, you can use the custom number format. Here's how:
1. You need to select the cell or range of cells you want to format.
2. Then right-click and choose Format Cells.
3. Go to the Number tab.
4. Select Custom.
In the Type box, enter the following custom format:
This should help!