Generate Excel using php, format cells as string number etc

I am generating an excel file using php.

The file gets created how ever strings with leadin开发者_高级运维g zeros example 0234 get converted to 234.

you want to set the number format to text

Range("A1").Select
Selection.NumberFormat = "@"

"@"

is the value for Text Format.

That should display leading 0's.

I hope that helps ;)