Stick with your original thread.
I'm sure Patrick will be back to work you through.
Gord Dibben MS Excel MVP
On Tue, 3 Nov 2009 09:38:21 -0800 (PST), srosetti <(E-Mail Removed)>
wrote:
>Problem is I have some data I need in fractions. but when I copy the
>fraction data into a text field it loses its number formatting and
>turns back into decimal form.
>
>I'll copy some real data from my spreadsheet so u can see whats going
>on. *This is what I see after I put the fractions from column H4 L4 to
>the end of text in column N4 'Widget'
>
>H4 L4 N4
>9 1/4 19 7/8 Widget 19.875" x 9.25"
>
>I have thousands of entries so I don't want to do this by hand.. I've
>tried everything I know to copy the fractions over, but no luck.
>Someone wrote a UDF function earlier, but it didn't exactly work for
>me. I'm trying to just simplify the steps by putting in the column H
>and L which have the decimal form and I converted them to fractions..
>My raw data is all in decimal so I have to work from that to get it to
>fractions.
>
>What I need my final data to look like is..
>
>N4 Widget 19 7/8" x 9 1/4"
>
>It would also be acceptable if the data ended up like
>
>N4 Widget 19 7/8 x 9 1/4 inches
>
>The quotes for inches is best, but if not possible I can use the word
>inches too.
>
>
>
>Thank You
|
Similar Threads
