Prev: Freeze Column
Next: Alternative of Vlookup
From: Rhett on 10 Apr 2010 18:47
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(++)==|
From: Dave Peterson on 10 Apr 2010 18:53
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
From: ozgrid.com on 10 Apr 2010 22:46
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" <Rhett(a)discussions.microsoft.com> wrote in message
news:B8D11458-3F5F-4375-BF6E-7133E6B90F17(a)microsoft.com...
> 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(++)==|

From: ozgrid.com on 10 Apr 2010 22:55
Oops, should $0.00;-$0.00;$* 0.00 then widen your Column.



--
Regards
Dave Hawley
www.ozgrid.com
"ozgrid.com" <dave(a)ozgrid.com> wrote in message
news:B2E96522-03E2-4709-9804-E6F81D988DF7(a)microsoft.com...
> 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" <Rhett(a)discussions.microsoft.com> wrote in message
> news:B8D11458-3F5F-4375-BF6E-7133E6B90F17(a)microsoft.com...
>> 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(++)==|
>

 | 
Pages: 1
Prev: Freeze Column
Next: Alternative of Vlookup