Excel 2003, 2007, 2010 custom formatting with the @ sign

I have a cell with the custom format:



what will the ampersand do the display of text.
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Enter text in a cell.
format that cell with the custom format


You will see the text. If you enter a number, you will see the number. If you enter a zero, you will see a - character.

Now format the cell with the custom format


You will not see any text in the cell, only in the formula bar. Numbers will display, zeros will be - again.

Now, with the custom format


nothing will ever show in the cell.

With the custom format


no numbers will ever show in the cell, but text will.

Does that make it clearer?

cheers, teylyn
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

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


will show numbers, a dash for zeros and no text.

cheers, teylyn
brothertruffle880Author Commented:
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?
brothertruffle880Author Commented:
PERFECT  teylyn  Thanks!!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.