Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 02-01-2014, 02:14 PM
BobBridges's Avatar
BobBridges BobBridges is offline how to change fraction representation to decimal representation as file attached Windows 7 64bit how to change fraction representation to decimal representation as file attached Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I think my solution last time was wrong. I thought you wanted it to calculate 5^(3 1/2), but you just want the superscripted part, 3.5. Then, if the superscript isn't a numeric value, you want back just the string without being changed. Is that right?

Still, you can modify my routine to make this work. Start by looking at the routine and see how it works. Then change it in this way: Detect whether the part of the text that is superscript can be viewed as a numeric value. 1) If it can, calculate the value (as I did), but return the superscript value rather than the base to that power. And 2) if it can't, don't do any calculation at all; just return the string.

I realize you may not know how to modify or even look at a worksheet function, such as the one I wrote for you in my last post. If so, don't worry; just tell me how much you understand, and I'll explain how to go on from that place.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make any fraction look the same as the auto fraction pintree3 Word 2 07-30-2013 12:49 PM
how to change fraction representation to decimal representation as file attached Please Help for VBA Code for Attached File.. krishnaoptif Word VBA 3 07-17-2012 12:29 AM
how to change fraction representation to decimal representation as file attached question in pictorial representation gsrikanth Excel 1 03-02-2012 11:45 AM
how to change fraction representation to decimal representation as file attached Outlook2003 - how to write attached file to folder nodari Outlook 1 05-26-2011 08:51 AM
Hyperlink to attached file in email message spino Outlook 0 08-05-2010 05:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft