Preserve formatting Leading Zeros in CSV

**rolta100** · 02-18-2014, 06:34 AM

I have CSV contains 04, 05, 00234, etc in columns

I want to preserve format Leading Zeros in numbers.

I added '04, formated a text field still format is getting loss ad answer is 4

What can be done to preserve formatting in CSV?

Also is there is alternate way to use with VBA?

**hemesh** · 02-18-2014, 06:43 AM

Hello , Have a look at
http://www.upenn.edu/computing/da/bo...dingZeros.html

To preserve zeros you need to tick text in column option

**Richard Buttrey** · 02-18-2014, 07:00 AM

Hi,

I'm assuming you are reading the csv data into an Excel workbook. In which case select the field in question when you get the option to parse the csv file and mark that field as 'text'.