Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Custom format text displays in Excel

Posted on 2014-04-23
2
Medium Priority
?
320 Views
Last Modified: 2014-04-27
Hello,

Hello, in Excel (2013) is there a way to define custom formatting for letters in the same way it is possible for numbers?

For example, after selecting some range (say Col B) and clicking Format Cells > Number tab > Custom, entering

">>> "#" <<<"

causes any number entered in Column B to be enclosed by chevrons. So say that the number 3 is entered in cell B9. The result will appear thus:

>>> 3 <<<

My question is whether or not there's a way to create a similar custom format which will be applied with a text entry. In other words, it would enable you to enter the letter "w" in the cell and display it as:

>>> w <<<

Thanks
0
Comment
Question by:WeThotUWasAToad
2 Comments
 
LVL 12

Accepted Solution

by:
duttcom earned 2000 total points
ID: 40019165
You are almost there with ">>> "#" <<<" but you will need to use an @ symbol instead of the hash to indicate that you want the special format to be applied to text, not a number.

">>> "@" <<<"
0
 

Author Comment

by:WeThotUWasAToad
ID: 40026225
That's perfect. It's great when such a simple and concise answer gives the solution. Many thanks!
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

963 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