Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Leading zero problem in spreadsheet

by davies (Vicar)
on Sep 27, 2012 at 10:04 UTC ( #995960=note: print w/ replies, xml ) Need Help??


in reply to Leading zero problem in spreadsheet

I haven't followed AnonyMonk's links & I don't know Spreadsheet:ParseExcel. However, there are two methods of dealing with leading zeros. The first is to save the string as text. The second is to format the numeric value to show a specified number of characters. I know it's not your weapon of choice, but in Re: Formatting cells in Excel I show both these techniques using Win32::OLE. Converting that to S::PE is left as an exercise for the reader!

Regards,

John Davies


Comment on Re: Leading zero problem in spreadsheet

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://995960]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2015-07-30 05:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls