ExcelBanter - Formatting cells to put the " mark for inches?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formatting cells to put the " mark for inches? (https://www.excelbanter.com/excel-programming/317382-formatting-cells-put-mark-inches.html)

QD[_2_]

Formatting cells to put the " mark for inches?

Is there a way to do that? I have tried to make it Special, Number and
General but it doesn't accept that.

quartz[_2_]

Formatting cells to put the " mark for inches?

Try entering the following formula in the "Custom" category:

#\"

The backslash tells Excel to treat the following character as a literal.

"QD" wrote:

Is there a way to do that? I have tried to make it Special, Number and
General but it doesn't accept that.

All times are GMT +1. The time now is 12:39 AM.