Customize accounting format
 

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(++)==|

Customize accounting format
 

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

Customize accounting format
 

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" wrote in message
...
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(++)==|

Customize accounting format
 

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



--
Regards
Dave Hawley
www.ozgrid.com
"ozgrid.com" wrote in message
...
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" wrote in message
...
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(++)==|