Generate Excel using php, format cells as string number etc

Question

I am generating an excel file using php.

The file gets created how ever strings with leading zeros example 0234 get converted to 234.

Answer 1

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 ;)