Specifying Cell Format in CSV File

Posted by Someone on Stack Overflow See other posts from Stack Overflow or by Someone
Published on 2010-03-09T00:33:37Z Indexed on 2010/03/09 0:36 UTC
Read the original article Hit count: 330

Filed under:
|
|
|

I am generating a csv file from a PHP array. It opens just fine in Excel and OpenOffice Calc, however the data in one of the column are zip codes. Excel makes the cell formats of the column number general by default. This results in the leading 0 getting dropped in zip codes. Is there any way I can specify the cell formats within the CSV file?

© Stack Overflow or respective owner

Related posts about csv

Related posts about .csv