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