Custom Number Format using "
Custom Number Format using "
(OP)
Does anybody know how to define a custom number format to produce a double quote (" to represent an inch)?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Custom Number Format using "
|
RE: Custom Number Format using "
TTFN
RE: Custom Number Format using "
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.
RE: Custom Number Format using "
=+""""
displays
"
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Custom Number Format using "
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.
RE: Custom Number Format using "
0/"
as your custom format
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
RE: Custom Number Format using "
RE: Custom Number Format using "
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.
RE: Custom Number Format using "
Ken