S
S
Sergey Blokhin2016-11-16 13:40:35
Google
Sergey Blokhin, 2016-11-16 13:40:35

How to format a number according to a given pattern in Google Sheets?

There is a number, for example, 39701026923544024.
You need to make it the following format: 3970102 692 354 4024.
What format should I set in Google Sheets?
Tried ####### ### ### ####- doesn't work.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Z
z555333, 2016-11-17
@z555333

It works for me both with lattices and with zeros.
00000 00000 000 0000

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question