Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Custom Number Format using "
- Thread starter Beggar
- Start date
electricpete
Electrical
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.
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.
electricpete
Electrical
Another example of the previous useage
=+""""
displays
"
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
=+""""
displays
"
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
electricpete
Electrical
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.
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.
- Thread starter
- #7
electricpete
Electrical
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.
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.
- Status
Similar threads
- Locked
- Question