@ in custom number fomatting

[lezawang]

Hi I used this code:

#,###;-#,###,-;@@@@

to my surprised whatever text i type in the cell, the text will get repeated 4 time, so if i type Hi, I will get

HiHiHiHi

Why is that? thank you.

 

[Rick Rothstein]

Hi I used this code:

#,###;-#,###,-;@@@@

to my surprised whatever text i type in the cell, the text will get repeated 4 time, so if i type Hi, I will get

HiHiHiHi

Why is that? thank you.

Each @ symbol represents the text in the cell, so if you put four @ symbols in the fourth field of the custom format, that text in the cells will be repeated four times (once per @ symbol).