Solved

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

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

773 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