Excel Custom Formatting, @ Character

If you’ve been reading about custom formatting in Excel you’ve probably stepped on the @ character. So what is it? For input values of the text type the @ character specifies where to put the the text. I will explain this using examples


Contents

Example 1:

In this example the simple @ sign character is used as the custom formatting:

@

Result:

Excel Custom Formating, @ sign, Example 1
As you can see the text in the first 2 rows are displayed exactly as they are. The custom formatting only affects the number in row 4. The number is stored as a text value in column B.

For more information about converting numeric value to text values in excel please see:

 


Example 2:

In this example the custom formatting below is used in column B:

@ "Post"

This custom formatting adds the text “Post” after the value in the cell. Basically the @ sign determines the position to print the value of the cell. In this case the value in the cell is printed in the beginning of the cell and the text value “Post” is printed after it:

Excel Custom Formating, @ sign, Example 2


Example 3:

In this example the custom formatting below is used in column B:

"Pre" @ "Post"

This is what the custom formatting does:

  1. Prints the text value “Pre”
  2. Prints a space
  3. The @ sign determines that the value in the cell will be printed at its location
  4. Prints another space
  5. Prints the text value “Post”

Result:

Excel Custom Formating, @ sign, Example 3

You can download the file for this article below:

See also:

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com

Leave a Reply

Your email address will not be published. Required fields are marked *