Cell formatting

[Gadgetman]

What does the "@" symbol at the end of a custom cell format do/mean? For
instance, is there a difference between the following two custom formats:

0.00;-0.00;;@

0.00;-0.00;;

Both seem to work, but I dont know if I need the "@" on the end.
Thanks

 

[JE McGimpsey]

@ is the token for text entered in the cell. By default the fourth
argument in the format is @, so you don't need it, but you can modify it:

0.00;-0.00;;"prefix "@

Then if you enter "hello" in the cell, it will display

prefix hello