Cell formatting

G

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
 
J

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
 
Top