Thread: How do I add " to the right of a number when formatting?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KSstudent KSstudent is offline
external usenet poster
  
Posts: 2
Default How do I add " to the right of a number when formatting?
Thank you: I was putting double quote double quote double quote now I see
the error.

"Niek Otten" wrote:

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