Hey everyone! I’m trying to figure out how to format numbers in Google Sheets. I’ve got a bunch of numbers that I need to add punctuation to, but I’m not sure how to do it automatically.
Here’s what I’m dealing with:
I have a column of numbers like this:
1234567
2345678
3456789
And I want them to look like this:
1.234.567
2.345.678
3.456.789
Is there a way to do this without manually adding the dots? It’s always the same pattern - a dot after every third digit from the right. I’ve got a pretty long list, so doing it by hand would take forever.
Any ideas on how to make this happen? Thanks in advance for your help!
I’ve been in your shoes before, and I get how frustrating it can be to format numbers manually. Here’s a trick that saved me tons of time: use the TEXT function. It’s a lifesaver for situations like this.
Try this formula:
=TEXT(A1, “#.###.###”)
Just replace A1 with whatever cell has your number. Copy this down your column, and you’re good to go. It’ll automatically add those dots exactly where you want them.
One thing to keep in mind: this turns your numbers into text. So if you need to do calculations later, you might need to convert them back. But for display purposes, it’s perfect.
Hope this helps! Let me know if you run into any snags.
Google Sheets offers a way to display numbers with punctuation through a custom number format. You can achieve this by selecting the column that contains your numbers, then navigating to Format, choosing Number, and selecting More Formats followed by Custom Number Format. In the dialog that appears, enter the format #.###.### to automatically insert a dot after every third digit from the right. This method only changes the display of the number while keeping its actual value intact, making it a convenient solution without altering the underlying data.