Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

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.
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Hello,

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
Avatar of brothertruffle880

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?
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
PERFECT  teylyn  Thanks!!!!