Hi,
I could use some help on how to select a specific digit within a number that has a decimal point; and then putting that digit into a different cell.
In example: I have the number 74.398; I'd like to have th "9" placed in a different cell exclusively.
Thank you,
Chubs
Hi use =mid() function
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
if its always same format eg ##.#X# where x is the number you want then
=MID(A1,(FIND(".",A1)+2),1)+0
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
thnks tom.
worked great.
Also appreciated twiggywales feedback as well!
Chubs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks