Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2012-03-20
4
Medium Priority
?
401 Views
Last Modified: 2012-04-19
I have a cell with the custom format:
0;-0;;@

and

0;-0;;

what will the ampersand do the display of text.
0
Comment
Question by:brothertruffle880
  • 2
  • 2
4 Comments
 
LVL 50
ID: 37744858
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
 

Author Comment

by:brothertruffle880
ID: 37856669
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
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 37859022
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
 

Author Comment

by:brothertruffle880
ID: 37865816
PERFECT  teylyn  Thanks!!!!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question