Modify Cell formatting

Posted on 2008-10-03 12:38:32-07 by sandeep78

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