Format or syntax writing inch values in a table 1

[ATsampalas]

In order to avoid any wrong interpretation how can I write inch values in a table ?
General Example (particularly Excel use)
1 1/4"
1 2/5"
1/2"
3 1/2"

Sincerely,
A. Tsampalas

 

[rb1957]

in a table i'd put the units in the header row.

or, messier, i'd use the next column and "in".

maybe use decimals (rather than fractions)

Quando Omni Flunkus Moritati

 

[Walterke]

who the heck uses /5ths in inches?

Anyway, maybe use a separate column for wholes & fractures, and a 3rd for the " or 'in' affix.

NX 7.5.5.4 with Teamcenter 8 on win7 64
Intel Xeon @3.2GHz
8GB RAM
Nvidia Quadro 2000

 

[Ussuri]

Use SI units?

 

[Walterke]

Ussuri
I'd like to see you try using SI units when you're ordering nipples & hydraulic tubing.

NX 7.5.5.4 with Teamcenter 8 on win7 64
Intel Xeon @3.2GHz
8GB RAM
Nvidia Quadro 2000

 

[drawoh]

ATsampalas,

Are those fitting sizes as per Walterke, or are those real numbers you intend to do calculations with?

If those are real numbers, I would put the units into the next cell. You can concatenate stuff in Excel.

="The Length is "&a3&" inches"


--
JHG

 

[IRstuff]

Really, you want chew up a whole column with the same entry in the entire column? Are you going to mix units? If not, then you have a single heading box that says "Dimension (in)" Done!

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[MintJulep]

Please define more clearly what you need.

Interpreted by what or who? By a human reader? By Excel? By an OCR program? By cats?

Are you doing math with these numbers in Excel?

 

[ATsampalas]

Thanks a lot for your answers.
For MintJulep (Mechanical):
> The interpretation of the table is by human readers ;
> Only visual observation (no math)
Sincerely,
A. Tsampalas

 

[TheTick]

Use a hyphen between the whole number and the fraction, e.g. 7-29/53.