=mid formula not working/showing result
I have put a formula in to the attache file in the second sheet. the critarea is in the first sheet with yellow color. i want the last digit "0" from 6107.40 in the second sheet arrow marked. I have made mid formulla. but it is not showing the zero. please somebody help me.
attaching file.
thanks,
Ryan
perhaps
=MID(TEXT(Invoice!F33,"0.00"),7,1)
Josie
if at first you don't succeed try doing it the way your wife told you to
hi Ryan. that's because F33 is a number. if you type in a number 6107.40 in a cell, you notice it only shows 6107.4 in the formula bar. you can try this in P23:
=MID(TEXT(Invoice!F33,"0.00"),7,1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
OR
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
It appears to be missing that zero because your original source data on sheet1 is 6107.4, not 6107.40 (even though it appears that way) if you look at that value in the fx line it is 6107.4.
EDIT: wow, in that little time it took me to type that it went from no replies to 3 replies, you guys are fast.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
you guys are awesome. thanks and it is solved.
You are welcome-from all of us- and thanks for the feedback.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
hi fotis,
lthanks for the reminder. By the way, can u help me advising, how can i change my avatar ? i am finding no way to update it.
When you'll get 100 posts, you'll be a Forum Contributor. Then you'll be able to use an Avatar!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks