| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert column with inches to 2 columns "feet" and "inches" | Excel Discussion (Misc queries) | |||
| Getting "question mark in block" at EOL in CSV files transformed fromXML | Excel Discussion (Misc queries) | |||
| how do i remove "mark as final" on a spreadsheet? | Excel Discussion (Misc queries) | |||
| how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
| Conditional Formatting multiple cells if one cells says "X"... | Excel Programming | |||
![QD[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
