I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Posted on 2008-10-03 12:38:32-07 by sandeep78
Modify Cell formatting
Hi, I am trying to find a way to modify the cell formatting on an excel spreadsheet. I would like to do it without writing into a new file. More like in-place editing. Any ideas, please Thanks for your time.
Direct Responses: 8931 | Write a response
Posted on 2008-10-03 13:50:29-07 by mtpaper in response to 8929
Re: Modify Cell formatting
Please give a specific example of what you are trying to do. In Excel, you can change the formating of a cell or a range of cells simply by selecting the cell or range and choosing Format.Cells or rightclick Format Cells. What are you trying to modify? What is the cell now, and what would you like it to be? Marion in NY
Direct Responses: 8938 | Write a response
Posted on 2008-10-03 17:17:20-07 by sandeep78 in response to 8931
Re: Modify Cell formatting
Hi, I want to change a Range of cells (A8 thru T36)...they are numeric. They are formatted as Accounting with 2 Decimal points. I would like to change the format to a custom code. _(* #,##0.00_);_(* (#,##0.00);_(* -??_);_(@_) - This is the custom format. Thanks.
Direct Responses: 8941 | Write a response
Posted on 2008-10-03 19:07:23-07 by mtpaper in response to 8938
Re: Modify Cell formatting
Hello - I think you would be better off looking at an Excel forum.... you can set custom codes in Excel via: Format-Cells-Number-Custom. In fact, I think your code is one of the options to select there. HTH - Marion
Direct Responses: 8942 | Write a response
Posted on 2008-10-03 19:26:01-07 by sandeep78 in response to 8941
Re: Modify Cell formatting
Thanks, But I am automating the process. Perl is my best option. I have seen scripts where they are formatting on new spread sheets. So I wanted to see if can do it on an existing spread sheet. Regards
Direct Responses: 9714 | Write a response
Posted on 2009-01-13 09:57:45-08 by nyk007 in response to 8942
Re: Modify Cell formatting
Hi guys, As a newly registered user I only want to say hi to everyone else who uses this forum. Spreadsheet is a very helpful package given by microsoft. It makes work easier. Thanks NYK Equity Loans
Direct Responses: Write a response