Hi, It is MS Excel jokes :)
You will get the same in MS Excel entering 541449400001629638 (it will round to 541449400001630000 for some not clear reason :)))))))) ) Asta ----- Original Message ----- From: "Miguel Demaerel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 23, 2003 3:47 PM Subject: Spreadsheet::WriteExcel cell format problem > Hoi > > I have a variable that contain 541449400001629638. This has to be a string. > Therefor I wont to define a column as Text, default it will use number. > I have tried set_num_format(0x01), set_num_format(0x49), > set_num_format(#################0). I always get 541449400001630000 or > 5.41449 +E17 > > Is this possible with this module, or do I have to use Win32::OLE? How do I > do that in Win32::OLE? > > Thanks in advance. > > Greetings Miguel > > > ///// > (o o) > ==============oOO==(_)==OOo============== > Miguel Demaerel > System Engineer - SCSA > Schlumberger > Raketstraat 98, B-1130 Brussels, Belgium > Tel +32 (0)2 724 93 17 > Fax +32 (0)2 724 92 92 > Email [EMAIL PROTECTED] > ========================================= > > _______________________________________________ > ActivePerl mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
