It's hard to tell what you're doing from the code you've posted, but I know that if I'm using excel the old fashioned way (manually) and want numbers entered as is, I put a single quote in front of them.
--chargrill
$/ = q#(\w)# ; sub sig { print scalar reverse join ' ', @_ }
+ sig
map { s$\$/\$/$\$2\$1$g && $_ } split( ' ', ",erckha rlPe erthnoa stJu
+" );
| [reply]
[d/l] |
| [reply] |
Spreadsheet::WriteExcel is a very powerful module. I have used it in the past to submit thousands of circuit change requests from one Telco to another when they insisted they wanted the requests in that format.
You can set the formatting of a cell using this module. Besides setting the cell value, you can set the cell format. Have a good read over the module documentation because it is very useful if you have particular formatting requirements (including colouring, cell width, and borders!). | [reply] |
The single-quote trick above should work. The canonical way to get a string in an Excel cell is to use a string formula; for example, set the cell to ="2-89". That will prevent Excel from trying to interpret the contents.
| [reply]
[d/l] |
Precede your string with a single quote. Write '2-89 to the cell instead of 2-89. | [reply] |