Jun 19, 2004 #1 Beggar Mechanical Mar 24, 2004 715 Does anybody know how to define a custom number format to produce a double quote (" to represent an inch)?
Does anybody know how to define a custom number format to produce a double quote (" to represent an inch)?
Jun 19, 2004 #2 IRstuff Aerospace Jun 3, 2002 44,761 The Help file tells you to use a single backslash followed by the character you want. TTFN Upvote 0 Downvote
Jun 19, 2004 #3 electricpete Electrical May 4, 2001 16,774 I'm not sure if this will help, but... When used in formula's, four double quotes results in a single double quote =+"Here Is a quote ->"&"""" returns Here Is a quote ->" ===================================== Eng-tips forums: The best place on the web for engineering discussions. Upvote 0 Downvote
I'm not sure if this will help, but... When used in formula's, four double quotes results in a single double quote =+"Here Is a quote ->"&"""" returns Here Is a quote ->" ===================================== Eng-tips forums: The best place on the web for engineering discussions.
Jun 19, 2004 #4 electricpete Electrical May 4, 2001 16,774 Another example of the previous useage =+"""" displays " ===================================== Eng-tips forums: The best place on the web for engineering discussions. Upvote 0 Downvote
Another example of the previous useage =+"""" displays " ===================================== Eng-tips forums: The best place on the web for engineering discussions.
Jun 19, 2004 #5 electricpete Electrical May 4, 2001 16,774 So a long way around would be to create a new sheet that refers to the corresponding cell in the first sheet. All cells except the cell in question are A1 = +Sheet1!A1 The cell to be displayed in inches is A1 = +Sheet1!A1&"""" There may be easier ways but I'm not familiar with how the custom number formats work ===================================== Eng-tips forums: The best place on the web for engineering discussions. Upvote 0 Downvote
So a long way around would be to create a new sheet that refers to the corresponding cell in the first sheet. All cells except the cell in question are A1 = +Sheet1!A1 The cell to be displayed in inches is A1 = +Sheet1!A1&"""" There may be easier ways but I'm not familiar with how the custom number formats work ===================================== Eng-tips forums: The best place on the web for engineering discussions.
Jun 19, 2004 #6 johnwm Computer Sep 26, 2002 806 Format | Cells | Custom and then use:[tt] 0/"[/tt] as your custom format Good Luck johnwm ________________________________________________________ To get the best from these forums read faq731-376 before posting Upvote 0 Downvote
Format | Cells | Custom and then use:[tt] 0/"[/tt] as your custom format Good Luck johnwm ________________________________________________________ To get the best from these forums read faq731-376 before posting
Jun 20, 2004 Thread starter #7 Beggar Mechanical Mar 24, 2004 715 Thanks all - that does the trick! Upvote 0 Downvote
Jun 20, 2004 #8 electricpete Electrical May 4, 2001 16,774 On Johnwm's message I see three characters for the format string. The 2nd and 3rd are / and " respectively The first looks like a rectangle on my screen. What is it and how do I type it? ===================================== Eng-tips forums: The best place on the web for engineering discussions. Upvote 0 Downvote
On Johnwm's message I see three characters for the format string. The 2nd and 3rd are / and " respectively The first looks like a rectangle on my screen. What is it and how do I type it? ===================================== Eng-tips forums: The best place on the web for engineering discussions.
