Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Using Excel's Flash Fill To Convert Numbers To Text

K2 Enterprises
5.09K subscribers
985 views 10 years ago
On occasion, you might find it necessary to convert numbers in an Excel spreadsheet into text. The most likely scenario for this need would be an instance where you need to import the data from Excel into another application and the other application requires “text” fields instead of “numeric” fields as the imported data. As you will see in this brief tip, you can easily convert numeric data into text data in Excel 2013 by using the newly added Flash Fill feature. ...more
...more
Comments are turned off. Learn more
Using Excel's Flash Fill To Convert Numbers To Text
1Likes
985Views
2015Apr 29
On occasion, you might find it necessary to convert numbers in an Excel spreadsheet into text. The most likely scenario for this need would be an instance where you need to import the data from Excel into another application and the other application requires “text” fields instead of “numeric” fields as the imported data. As you will see in this brief tip, you can easily convert numeric data into text data in Excel 2013 by using the newly added Flash Fill feature.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers