×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Format or syntax writing inch values in a table

Format or syntax writing inch values in a table

Format or syntax writing inch values in a table

(OP)
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

RE: Format or syntax writing inch values in a table

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

RE: Format or syntax writing inch values in a table

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

RE: Format or syntax writing inch values in a table

Use SI units?

RE: Format or syntax writing inch values in a table

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

RE: Format or syntax writing inch values in a table

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

RE: Format or syntax writing inch values in a table

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?

RE: Format or syntax writing inch values in a table

(OP)
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

RE: Format or syntax writing inch values in a table

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources