Linked cell for activex combo box

%3CLINGO-SUB%20id%3D%22lingo-sub-1313908%22%20slang%3D%22en-US%22%3ELinked%20cell%20for%20activex%20combo%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1313908%22%20slang%3D%22en-US%22%3EHey%20there%20guys%20how%20are%20you%20all%20doing%20%3F%20Am%20facing%20in%20issue%20that%20took%20me%20ages.%20So%20I%20have%20created%20an%20active%20combo%20box%20with%20the%20list%20of%20range%20containing%200.03%2C%200.04%20and%200.1.%20And%20selected%20cell%20is%20b5.%20Then%20when%20I%20preform%20a%20calculation%20like%20%3DB5*5%20the%20result%20is%20%23value.%20Then%20I%20discovered%20that%20the%20number%20are%20in%20text.%20I%20tried%20to%20change%20it%20to%20number%20but%20I%20could%20not%20find%20a%20way.%20Does%20anyone%20have%20any%20idea%20on%20how%20to%20change%20those%20text%20%E2%80%9C0.03%E2%80%9D%20to%20a%20number%20format%20%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1313908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1315193%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20cell%20for%20activex%20combo%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1315193%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625176%22%20target%3D%22_blank%22%3E%40Alasad_aladawi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DVALUE(B5)*5%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
Hey there guys how are you all doing ? Am facing in issue that took me ages. So I have created an active combo box with the list of range containing 0.03, 0.04 and 0.1. And selected cell is b5. Then when I preform a calculation like =B5*5 the result is #value. Then I discovered that the number are in text. I tried to change it to number but I could not find a way. Does anyone have any idea on how to change those text “0.03” to a number format ?
1 Reply
Highlighted

@Alasad_aladawi 

Try this:

=VALUE(B5)*5