how can i write vba code for replacing continuos fraction numbers in on row

**baig123** · 06-19-2014, 01:00 AM

i have attached my excelsheet Please help me out I am struck here

i ahve continous fraction numbers in every attribute value

how can i write vba code for replacing continuos fraction numbers in on row

Attribute name1 Attribute Value1

materials1 1/2 IN ID, 2/3 IN LG, 4/5 IN OD 1/4 IN THK
materials2 1/2 IN ID, 2/3 IN LG, 4/5 IN OD
materials3 1/2 IN ID, 2/3 IN LG

example: 1/2 IN ID, 2/3 IN LG, 4/5 IN OD 1/4 IN THK in a single row

i have TOOL OUT sheet

ModelNumber Attribute Value Replace Value

1 materials 2/4 IN LG, 3/4 IN ID, 5/9 IN OD,1/15 IN THK
2 materials 1/2 IN LG, 2/9 IN
3 materials 4/15 IN
4 materials 5/18 IN
5 materials 4/19 IN
6 materials 2/4 IN
7 materials 1/2 IN
8 materials 4/15 IN
9 materials 5/18 IN
10 materials 4/19 IN LG, 9/8 IN
11 materials 2/4 IN LG, 3/4 IN ID, 5/9 IN OD,1/15 IN THK

iwant this to converted in (Replace value column)
example 0.5 IN LG, 0.75 IN ID, 0.55 IN OD,0.06 IB THK

**patel45** · 06-19-2014, 01:44 AM

Please Login or Register  to view this content.

**baig123** · 06-19-2014, 07:55 AM

i just want that 1/2 should display .5 IN LG other values should display maximum 3 or 2 values(1/7--> .143,1/4 as .25)

but i some doubt that if there is 1/2 -->0.50 1/7-->0.143

i want this should be display in this format -->(1/2)---->.5 and 1/7-->.143
followed 1/4-->.25
Fraction Decimal
15/16 .937
7/8 .875
13/16 .812
3/4 .75
11/16 .687
5/8 .625
9/16 .562
1/2 .5
7/16 .437
3/8 .375
11/32 .343
5/16 .312
9/32 .281
1/4 .25
15/64 .234
7/32 .218
13/64 .203
3/16 .187
23/128 .179
11/64 .171
21/128 .164
5/32 .156
19/128 .148
9/64 .140
1/8 .125
7/64 .109
3/32 .093
5/64 .078
1/16 .062
3/64 .046
1/32 .031
1/64 .015

now it showin like this

.500 IN HD, .500 IN HUB, .071 IN OD, .125 IN THK
.500 IN HD
.200 IN THK
.143 IN ID

i want this type it should display how can i do it

.5 IN HD, .5 IN HUB, .071 IN OD, .125 IN THK
.5 IN HD
.2 IN THK
.143 IN ID

**jindon** · 06-19-2014, 09:20 AM

Do you want it like this?

**vnzerem** · 06-19-2014, 03:32 PM

Very Neat work Jindon...thanks for sharing your knowlegde

**baig123** · 06-20-2014, 03:06 AM

its working what i am saying that

if where value like this 1/2 it should (.5 HD or LG Or THK or OD or ID any thing it maybe)
2/4 it should (.5 HD or LG Or THK or OD or ID any thing it maybe)
9/2 it should (4.2 HD or LG Or THK or OD or ID or any thing it maybe)

it should display maximum 3 values i this fraction value
if where value like this 9/13 it should (.692 HD or LG Or THK or OD or ID any thing it maybe)
etc

**jindon** · 06-20-2014, 03:12 AM

Change the pattern

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

vnzerem

Thanks

**baig123** · 06-20-2014, 06:29 AM

i am very Sorry for that its working fine

how can modify this because in my sheet i having different fraction numbers(1/2,1-1/2,3-4/15,4-1/16) like

example
it should display like this ('-' relate as '/') fractions
fraction decimal

1-1/2 IN LG,1/2 IN MM 1.5 IN LG,0.5 IN MM
1/2 IN OD,2-3/4 IN OD 0.5 IN LG,2.75 IN OD
2-3/4 IN ID,1/2 IN LG 2.75 IN ID,0.5 IN LG
-
-
etc

Please Login or Register  to view this content.

**jindon** · 06-20-2014, 06:34 AM

baig123

Do you have any words for appreciation when you get the help in India?

**baig123** · 06-21-2014, 12:44 AM

Please help me out

i have code which replaces fraction to decimal but i have some issues in that i my having different fractions like this code is converting fractions but diffferent fractions like(1-2/4,2-1/2,3-1/15)

15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID

this type of fractions like(1-1/16,2-3/64....etc) it is converting

example;;after converting 1/16 it should convert 1/0.062-->16.129

Please Login or Register  to view this content.

**protonLeah** · 06-21-2014, 12:52 AM

To attach a Workbook
(please do not post pictures of worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

**baig123** · 06-21-2014, 12:58 AM

attched my excel sheet

see tool-output there sheet

run macros there if i click the replay it converts(fraction to decimal) in the replace value

**protonLeah** · 06-21-2014, 01:17 AM

Please Login or Register  to view this content.

**baig123** · 06-21-2014, 05:09 AM

its working Thanks

but some doubts that if the value 1-1/16 ----> 2.063
2-3/64 --->2.0467
its taking round fiigure but i dont need of round figure
how can i do it
1-1/16 --->1.062
2-1/16 --->2.062
2-3/64 --->2.046

**jindon** · 06-21-2014, 06:17 AM

Duplicate post

http://www.excelforum.com/excel-prog...in-on-row.html

**Fotis1991** · 06-21-2014, 06:27 AM

No appriciation for the people that try to help you...

I'll merge these 2 threads as you have replies to both of them but next time that you'll do it9duplicate threads) you'll be a banned user.

**baig123** · 06-21-2014, 06:57 AM

i am very sorry for that

**jindon** · 06-21-2014, 08:04 AM

This one will never learn

http://www.excelforum.com/excel-prog...d-numbers.html

http://www.excelforum.com/excel-prog...es-number.html

how can i write vba code for replacing continuos fraction numbers in on row

LinkBack

Thread Tools

Rate This Thread

Display

how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

i have code which replaces fraction to decimal but i have some issues in that

Re: i have code which replaces fraction to decimal but i have some issues in that

Re: i have code which replaces fraction to decimal but i have some issues in that

Re: i have code which replaces fraction to decimal but i have some issues in that

Re: i have code which replaces fraction to decimal but i have some issues in that

Re: i have code which replaces fraction to decimal but i have some issues in that

Re: i have code which replaces fraction to decimal but i have some issues in that

Re: how can i write vba code for replacing continuos fraction numbers in on row

Re: how can i write vba code for replacing continuos fraction numbers in on row

Thread Information

Users Browsing this Thread

Similar Threads

Replacing Fraction to decimal it is not converting

i need an replacing fraction to decimal conversion in vba excel

[SOLVED] Number Format to whole numbers, or if fraction, allow one decimal

macro to fill out a column with continuos numbers

[SOLVED] How do you enter numbers in a fraction format ? (78/27)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions