ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel-custom format using inches symbol (") (https://www.excelbanter.com/excel-worksheet-functions/18594-excel-custom-format-using-inches-symbol-%22.html)

nannieree

excel-custom format using inches symbol (")
 
I am using Excel and need to know how to create a custom format that adds the
symbol for inches next to a number.

Thank you

JE McGimpsey

One way is to use the escape sequence \<character:

Format/Cells/Number/Custom 0\"

In article ,
nannieree wrote:

I am using Excel and need to know how to create a custom format that adds the
symbol for inches next to a number.



All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com