Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fractions in 16ths format - reducing to LCD
I have data in millimeters and converting in aanother cell to inch fractions
in 16ths format (result must be in 16 increments). How do I reduce to LCD - I do not want to see 8/16 but do want 1/2. -- Thanks, Derek |
#2
|
|||
|
|||
You have an answer elsewhere.
-- HTH RP (remove nothere from the email address if mailing direct) "Derek" wrote in message ... I have data in millimeters and converting in aanother cell to inch fractions in 16ths format (result must be in 16 increments). How do I reduce to LCD - I do not want to see 8/16 but do want 1/2. -- Thanks, Derek |
#3
|
|||
|
|||
On Thu, 16 Jun 2005 13:33:08 -0700, "Derek"
wrote: I have data in millimeters and converting in aanother cell to inch fractions in 16ths format (result must be in 16 increments). How do I reduce to LCD - I do not want to see 8/16 but do want 1/2. Round your result to the nearest 16th, and format the cell as a fraction with up to two digits. To round: =ROUND(your_formula*16,0)/16 Format code: # ??/?? --ron |
#4
|
|||
|
|||
This works too:
=ROUND(your_formula/16,0)*16 <g Biff "Ron Rosenfeld" wrote in message ... On Thu, 16 Jun 2005 13:33:08 -0700, "Derek" wrote: I have data in millimeters and converting in aanother cell to inch fractions in 16ths format (result must be in 16 increments). How do I reduce to LCD - I do not want to see 8/16 but do want 1/2. Round your result to the nearest 16th, and format the cell as a fraction with up to two digits. To round: =ROUND(your_formula*16,0)/16 Format code: # ??/?? --ron |
#5
|
|||
|
|||
On Fri, 17 Jun 2005 01:40:53 -0400, "Biff" wrote:
This works too: =ROUND(your_formula/16,0)*16 <g To do what? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) |