View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How do I add " to the right of a number when formatting?

What does your format look like that removes the leading 0?

This custom format will add the " but does not remove the leading 0:

General"''";-General"''"

Note that the quotes are a double quote then 2 single quotes then another
double quote.

" ' ' "

Biff

"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.