Inches.xls

<div>
Geekamo,<br />
<br />
<i>General&quot; ''&quot;</i><br />
(Between the double-quotes is a space followed by two single quotes.)<br />
<br />
<b>Edit:</b> The double quotes aren't required, so the following is sufficient...<br />
<i>General ''</i><br />
(A space followed by two single-quotes.)<br />
<br />
Regards,<br />
Brian.
</div>


Geekamo,

General" ''"
(Between the double-quotes is a space followed by two single quotes.)

Edit: The double quotes aren't required, so the following is sufficient...
General ''
(A space followed by two single-quotes.)

Regards,
Brian.

<div>
This is great! &nbsp;Thank you!<br />
<br />
~ Geekamo
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
Here's my problem...<br />
<br />
User enters &quot;18&quot; into cell. I want to cell to format into inches. &nbsp;If you look at cell A2, that's exactly how I want it to be appear.<br />
<br />
Just to be clear, cell A2 is ONLY showing you want I want it to look like.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/01_w03/629251/Formatting-Inches.png" target="_blank" title="Formatting Inches (19 KB)"><img alt="Formatting Inches" class="file-block lazyload" style="max-width: 296px;" data-src="https://filedb.experts-exchange.com/incoming/2013/01_w03/629251/Formatting-Inches.png" /></a><br />
Thank you in advance for your help!<br />
<br />
~ Geekamo
</div>
</div>


Formatting-Inches.png

Hello Experts,

Here's my problem...

User enters "18" into cell. I want to cell to format into inches.  If you look at cell A2, that's exactly how I want it to be appear.

Just to be clear, cell A2 is ONLY showing you want I want it to look like.



Thank you in advance for your help!

~ Geekamo

Custom Cell Formatting

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