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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Formatting data coming from external source into excel
- Thread starter lwilt
- Start date
Excel Facts
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Similar threads
- Question
- Replies
- 0
- Views
- 66
- Replies
- 1
- Views
- 199
- Replies
- 7
- Views
- 290
- Question
- Replies
- 0
- Views
- 767
