Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA)

  • Thread starter Thread starter ExceLearner
  • Start date Start date
E

ExceLearner

I am getting file with one column of percentages in "0.7300%" format. I take thie file change the columns in different order using simple links from one tab to another.

I need a way (NO MACRO / VBA) to Convert numbers stored as text to numbers.Right now I am making the change using error message that is appreaing. Is there a formula or set of formaulas to get this done so one this file isgetting converting this happens automatically?

Thanks,
 
Back
Top