brothertruffle880
asked on
Excel 2003, 2007, 2010 custom formatting with the @ sign
I have a cell with the custom format:
0;-0;;@
and
0;-0;;
what will the ampersand do the display of text.
0;-0;;@
and
0;-0;;
what will the ampersand do the display of text.
ASKER
I'm sorry. You are correct. I meant the AT sign "@"
I've been trying to determine exactly what the @ sign does. I take it out, I put it in. No difference. Can you give me an example of the at sign being used and then the same example of the at sign not there so that I can see what the at sign does?
I've been trying to determine exactly what the @ sign does. I take it out, I put it in. No difference. Can you give me an example of the at sign being used and then the same example of the at sign not there so that I can see what the at sign does?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
PERFECT teylyn Thanks!!!!
not sure I understand the question. What ampersand? An ampersand is this: &
The @ sign is called the "at" sign.
The custom format has the syntax
[positive number];[negative number];[zero value];[text]
If you omit the @ sign at the end of a custom format, text will not be displayed, even if it is entered into the cell. A format of
;;;
will not show anything. A format of
;;;@
will not show numbers, only text. A format of
0;-0;-;
will show numbers, a dash for zeros and no text.
cheers, teylyn