Solved

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

Posted on 2012-03-20
4
356 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

Expert Comment

by:Ingeborg Hawighorst
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 earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cascading dropdown 9 28
ADD New Entries 7 16
Pivot help - Display only Is Not Null 7 16
nested if statement in excel help 4 12
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now