CODEWITHSUNDEEP
excel
softshipper
softshipper

Reputation: 34071

Format numbers into text

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?

Upvotes: 0

Views: 42

Answers (1)

BrakNicku
BrakNicku

Reputation: 5991

Please try:

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

\ escapes possible decimal separator.

Upvotes: 2

Related Questions