| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert numbers stored as text to numbers - Automatically - Macro
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 is getting converting this happens automatically? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers stored as text to numbers | Excel Discussion (Misc queries) | |||
| convert numbers stored as numbers to text | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
