Convert variable #'s in a gen. format to a # that can be used
Copy the value from A3 (the one that results in #Value!) directly into a
response to this post. Do not re-type or edit in any way.
Steve wrote:
This
=--TRIM(RIGHT(SUBSTITUTE(TRIM(A3),":",REPT(" ",10)),10))
Gives me a #Value!
Also isnumber for that cell is false.
Thanks,
Steve
|