<div>
That's perfect. It's great when such a simple and concise answer gives the solution. Many thanks!
</div>


That's perfect. It's great when such a simple and concise answer gives the solution. Many thanks!

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Hello, in Excel (2013) is there a way to define custom formatting for letters in the same way it is possible for numbers?<br />
<br />
For example, after selecting some range (say Col B) and clicking Format Cells &gt;&nbsp;Number tab &gt;&nbsp;Custom, entering<br />
<br />
&quot;&gt;&gt;&gt;&nbsp;&quot;#&quot; &lt;&lt;&lt;&quot;<br />
<br />
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:<br />
<br />
&gt;&gt;&gt;&nbsp;3 &lt;&lt;&lt;<br />
<br />
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 &quot;w&quot; in the cell and display it as:<br />
<br />
&gt;&gt;&gt;&nbsp;w &lt;&lt;&lt;<br />
<br />
Thanks
</div>
</div>


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

Custom format text displays in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.