I've been banging my head on my desk for two days over this problem!
I want to customize the accounting format to show 0 as: $ 0.00
(with a $ to the far left of the cell and 0.00 to the far right. What
symbol/space/other thing do I use to create this extra space?
-- AAAaaarrrgggaaah! It's only 5 days until April 15th!!!!

I've always wanted to be somebody....
Now I see I should have been more specific.

Find a Cure
=:-)-X(++)==|

Try a custom format of:
$* 0.00

DollarSign, Asterisk, spacecharacter, 0.00



Rhett wrote:
>
> I've been banging my head on my desk for two days over this problem!
> I want to customize the accounting format to show 0 as: $ 0.00
> (with a $ to the far left of the cell and 0.00 to the far right. What
> symbol/space/other thing do I use to create this extra space?
> -- AAAaaarrrgggaaah! It's only 5 days until April 15th!!!!
>
> I've always wanted to be somebody....
> Now I see I should have been more specific.
>
> Find a Cure
> =:-)-X(++)==|

--

Dave Peterson

Try a Custom Format of;
$0.00;-$0.00;$* 0.00


http://www.ozgrid.com/Excel/CustomFormats.htm




--
Regards
Dave Hawley
www.ozgrid.com
"Rhett" <(E-Mail Removed)> wrote in message
news:B8D11458-3F5F-4375-BF6E-(E-Mail Removed)...
> I've been banging my head on my desk for two days over this problem!
> I want to customize the accounting format to show 0 as: $ 0.00
> (with a $ to the far left of the cell and 0.00 to the far right. What
> symbol/space/other thing do I use to create this extra space?
> -- AAAaaarrrgggaaah! It's only 5 days until April 15th!!!!
>
> I've always wanted to be somebody....
> Now I see I should have been more specific.
>
> Find a Cure
> =:-)-X(++)==|

Oops, should $0.00;-$0.00;$* 0.00 then widen your Column.



--
Regards
Dave Hawley
www.ozgrid.com
"ozgrid.com" <(E-Mail Removed)> wrote in message
news:B2E96522-03E2-4709-9804-(E-Mail Removed)...
> Try a Custom Format of;
> $0.00;-$0.00;$* 0.00
>
>
> http://www.ozgrid.com/Excel/CustomFormats.htm
>
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Rhett" <(E-Mail Removed)> wrote in message
> news:B8D11458-3F5F-4375-BF6E-(E-Mail Removed)...
>> I've been banging my head on my desk for two days over this problem!
>> I want to customize the accounting format to show 0 as: $
>> 0.00
>> (with a $ to the far left of the cell and 0.00 to the far right. What
>> symbol/space/other thing do I use to create this extra space?
>> -- AAAaaarrrgggaaah! It's only 5 days until April 15th!!!!
>>
>> I've always wanted to be somebody....
>> Now I see I should have been more specific.
>>
>> Find a Cure
>> =:-)-X(++)==|
>