Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Numbers vs Values
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jim Thomlinson, post: 6001770"] Lets see if I can do a little better on this than I did on your last. Try this formula to get the value =VALUE(LEFT(A1,2)+(VALUE(MID(A1,4,1)))/10) Where 12.2a or 12,2a is in cell a1 HTH [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Numbers vs Values
Top
