Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add " to the right of a number when formatting?
Single quote, surrounded by double quotes, at the end of your custom format.
Joerg "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add " to the right of a number when formatting?
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. | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting: display blank when "O", 2 decimal when a number is d | New Users to Excel | |||
I can't get custom number formatting to "take" | Excel Worksheet Functions | |||
find/replace "cr" from end of number to "-" in front of number | Excel Discussion (Misc queries) | |||
Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
"IF" statement & "strikethrough" formatting | Excel Worksheet Functions |