开发者

Generate Excel using php, format cells as string number etc

开发者 https://www.devze.com 2023-01-06 14:06 出处:网络
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

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

0

精彩评论

暂无评论...
验证码 换一张
取 消