Forum Discussion
Format to display 20 numbers in groups of four
What format can I use in order to display 89462046211305792124 (20 numbers) as "8946 2046 2113 0579 2124" (displayed in group of four digits)?
Hi Erik,
If you keep it as text, to my knowledge it's not possible to insert any symbols into the text by formatting.
If keep as number Excel rounds it to 15 digits (max for numbers representations), but for numbers in general you may apply grouping using custom format like
0000 0000 0000 0000 0000