|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 10th, 2010, 11:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(++)==| 
|
|
#2
April 10th, 2010, 11:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
April 11th, 2010, 03:46 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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(++)==|
|
|
#4
April 11th, 2010, 03:55 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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(++)==|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
