How to Keep Leading Zeros in Excel CSV Import
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Gx5fwAt64NY
Download the featured file from our website https://www.bluepecantraining.com/how... • In this video I demonstrate how to successfully import CSV data where values contain leading zeros. By default leading zeros are omitted from the import unless the values are recognised as text. • Firstly, I show you how to import the CSV file using Power Query then secondly using the Text Import Wizard which is available in older versions of Excel. • This video will be useful if you have the following queries: • How do I stop Excel from dropping the leading zeros? • How do I keep text format in CSV? • How to preserve leading zeros in Excel CSV import? • ------------------------
#############################