Hello,
I have made a drop down list of numbers ranging from 1 to 7 with 0.1 increments. My list starts from A2 as 1 and A3=A2+0.1 and so on. When I choose 6.2 from the list, it is shown as 6.199999999. For all the numbers higher than 6.2, I have this problem.
Could you please advise me on this problem?
Thank you very much,
Payman
Try using the text function
Formula:
Please Login or Register to view this content.
Your dropdown list must be impractical
Why not use three dropdowns 0=9,0-9, 0-9
Or three spin buttons
Last edited by mehmetcik; 08-26-2017 at 02:13 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you very much for the prompt reply.
Now the cells are texts, not numbers to be used later in my formulas. Could you please make a comment on this as well.
I am also wondering why this problem occurred. I have done this kind of job several times before and only this time I have such problem.
you can use concat function or & to join the four elements together
A1 =6
A2 = .
A3=1
A4 = 6
B2 = Concat("A1:A4")*1
or
B2 =(A1 & A2 & A3 & A4)*1
Last edited by mehmetcik; 08-26-2017 at 02:48 PM.
I really appreciate your proposed method. I would rather try to understand why the excel reads 6.19999999 instead of 6.2. This way I could have a more general insight.
Do you think it is a normal behavior? or perhaps something has been changed in the setting?
Excel does not store numbers as decimals, they are stored as binary numbers so errors will creep in.
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks