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.
brothertruffle880Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
0
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?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Enter text in a cell.
format that cell with the custom format

0;-0;-;@

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

0;-0;-;

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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
brothertruffle880Author Commented:
PERFECT  teylyn  Thanks!!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.