Re: Excel - how do I format negative Costs in Red

I don't have an answer to your question, but I have a couple tips that should save you a bit of typing in the future.

@al = qw (A B C D E F G H I J K L M N O P Q R S T U V W X Y Z);
[download]

can be replaced by (see Range Operators):

@al = 'A' .. 'Z';
[download]

You could use the following to initialize your hash:

my %dp_numfmt = (
    dp0 => "0",
    dp1 => "0.0",
    dp2 => "0.00",
    # etc.
);
[download]

Comment on Re: Excel - how do I format negative Costs in Red Select or Download Code

Replies are listed 'Best First'.
Re^2: Excel - how do I format negative Costs in Red by Fletch (Bishop) on Feb 02, 2010 at 15:18 UTC
If you're going for saving typing . . . `my %dp_numfmt; $dp_numfmt{"dp$_"} = join( ".", "0", "0"x$_) for 0..5;` [download] The cake is a lie. The cake is a lie. The cake is a lie.	[reply] [d/l]
Re^3: Excel - how do I format negative Costs in Red by merrymonk (Hermit) on Feb 02, 2010 at 15:49 UTC
hmmm - but then I really would have to know what I was doing!	[reply]
Re^2: Excel - how do I format negative Costs in Red by merrymonk (Hermit) on Feb 02, 2010 at 14:37 UTC
Thanks for those. I am alwyas 'up' for saving typing!!	[reply]