 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007How 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. 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 >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. Single quote, surrounded by double quotes, at the end of your custom format. Joerg >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. Format Custom as .000"'" (Quote, single quote, quote)  SignatureKind regards, Niek Otten Microsoft MVP - Excel |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. Thank you: I was putting double quote double quote double quote now I see the error. > Format Custom as .000"'" (Quote, single quote, quote) > [quoted text clipped - 4 lines] > | quotation mark the symbol for inches. I do not know how on the custom > | formatting I just get an error. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.