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

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert numbers stored as text to numbers - Automatically - Macro 2
How can the font and size of (all) citation numbers be altered? 1
Removing Line Numbers 4
Excel does not accept text format! 0
Converting URLs in comments to Markdown-formatted links 2
Select Text to End of Footnote 9
WORD VBA Search and switch to advanced ... 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top