Give Me Cake

CakePHP Baking, Internet Marketing, SEO, Design and more

Leading Zeros removed by Spreadsheet?

Posted on | September 2, 2009 | No Comments

Use =”000123″ when exporting zero padded numbers in CSV to prevent the leading zeros from being removed. Works in Excel and OpenOffice

$csv->addField(‘=”‘.$student['Cda']['branch_code'].’”‘);

No TweetBacks yet. (bookmark

Comments

Leave a Reply





  • Give me Cake?

    Givemecake.dev-work.com a collection of web application development tips, tutorials and resources.
  • See Your Ads Here

  • See Your Ads Here

  • Meta