I need to convert a exported number to a value . i have tried - 1, copy, paste special, multiply - doesnt work
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
convert a number to a value
0
Answers
0
=VALUE(A1)This formula will convert a string (text) in A1 into a numeric value. You might use this formula in a blank column next to the imported one, convert the formulas to values with copy / paste special > Values, and then delete the original column.