Hi all,
I have a spreadsheet with 20 fields(columns) in which the fifth column is a numerical column with records such as 00024,00455, 00234,556670,465700,00456 etc. I want to consider the leading zeros for this column so that I can use some logic. Now the problem is that I am unable to add the double quotes in front and end of the fifth column so that I will get the leading zeroes. Otherwise without double quotes, If I ftp the file into unix machine as .CSV file, I am not getting the leading zeroes. Any help is greatly appreciated.
thanks in advance,
sean......