-
Tommy,
Running your code works. I should have tested first.... but was looking at some of the extra lines and thought they were not poignant.
I removed the /2 line and that provides me the answers I am looking for.
Right On!
There are couple of areas that I would like to explore further-
The spacing on fraction conversion looks a little wide- like two spaces inbetween the whole number and the fraction. Can this be made to look as if the numbers are closer?
I had to change the .NumberFormat to "0.000" to deal w/ .375 decimal values and this may have an effect on the appearance.
Maybe the answer is to convert to text and remove extra spaces.
I will monkey w/ this now until I hear back.
Thanks,
Doug
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules