0

I have following two numbers in excel: 

670047 164004100000

and want to format as follow: 

000.000.670.047 164.004.100.000

How can I use TEXT function for my desired result?

Improve this question

1 Answer 1

Reset to default
2

Please try:

=TEXT(A1,"000\.000\.000\.000")

\ escapes possible decimal separator.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.