Thread: How do I add " to the right of a number when formatting?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default How do I add " to the right of a number when formatting?
Format Custom as .000"'" (Quote, single quote, quote)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KSstudent" wrote in message ...
|I am trying to format a column of numbers example.
| 0.152
| 0.025
| I have figured out how to remove the first zero now I need to add a single
| quotation mark the symbol for inches. I do not know how on the custom
| formatting I just get an error.
|


Reply With QuoteReply With Quote