I'm pulling in data from an external source into excel PT and part of the information coming in that I need is in a text format but I need it to be as a number so that I can use it to create a calculated field. What would be the best way to be able to convert that field to a number when the data gets dumped into the PT so that I can create the calculated field I need?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formatting data coming from external source into excel
- Thread starter lwilt
- Start date
Similar threads
- Question
- Question
