https://www.machform.com/forums/ MachForm Community Forums Topic: zero start value disappears in Excel en Sun, 03 May 2026 23:05:06 +0000 https://www.machform.com/forums/topic/zero-start-value-disappears-in-excel#post-8274 Mon, 04 Jan 2010 01:19:35 +0000 arnaudboub 8274@https://www.machform.com/forums/ <p>Great</p> <p>Thank you very very much<br /> ;-) </p> https://www.machform.com/forums/topic/zero-start-value-disappears-in-excel#post-7826 Fri, 30 Oct 2009 16:01:15 +0000 yuniar 7826@https://www.machform.com/forums/ <p>This is because Excel automatically format those numbers and remove the leading zero.<br /> To avoid this behaviour, we can force to write those fields as text.</p> <p>Edit your "export_entries.php", search around line 375 and you'll find this:</p> <pre><code>$worksheet-&gt;write($row_num, $col_num, $data);</code></pre> <p>replace that code with this one:</p> <pre><code>$worksheet-&gt;writeString($row_num, $col_num, $data);</code></pre> <p>That should display the leading zero. </p> https://www.machform.com/forums/topic/zero-start-value-disappears-in-excel#post-7816 Thu, 29 Oct 2009 17:36:30 +0000 arnaudboub 7816@https://www.machform.com/forums/ <p>hello,<br /> when I export to Excel a telephone number or, if there is a zero start value, it disappears in the data sheet view!<br /> How to make it appear (French phone number starts with "0" zero)</p> <p>Thank you </p>