View Single Post
  #1   Report Post  
Turk
 
Posts: n/a
Default convert character to value at relative cell

Dear all,

I have a character "400.00" in cell B3, how to convert this character to
value?
As I know, by using of the formula VALUE, it can only convert the absolute
value (400.00),
but cannot convert the relative value at cell B3.

Thanks

Turk