convert a number to a value

0

I need to convert a exported number to a value . i have tried - 1, copy, paste special, multiply - doesnt work

Answer
Discuss

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login