View Single Post
  #1   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?

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.