public marks

PUBLIC MARKS with tag "mon amour"

16 January 2012 17:45

CSV Comma Separated Value File Format - How To - Creativyst - Explored,Designed,Delivered.(sm)

by night.kame

If you have a table for export in which leading zeros and spaces have significance AND that file will only be viewed in Excel, then you can use an Excel specific convention in those fields where leading zeros or spaces should be preserved (in Excel). To implement this fix, double quote each field with leading zeros or spaces and place an equals sign (=) directly ahead of the first quote

W00t!

PUBLIC TAGS related to tag "mon amour"

excel +  

Active users

night.kame
last mark : 16/01/2012 17:46