Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formating cell
I have a very simple worksheet with formulas. Here is what I have:
ColumnB ColumnC ColumnD Sales Amt Sales Return Net Sales $591518.00 $12638.00 $578880.00 My Formula for calculating Column D is: =IMSUB(B4,C4). Column B & C shows the $ sign. When the calculation for Column D appears it does not have the dollar sign. The entire worksheet is formatted for currency with two decimals. I checked the individual cell and it is also formatted for currency with two decimals. What am I missing? This is a school assignment. Thanks The -- Bandit |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formating cell
try this
=TEXT(IMSUB(B4,C4),"$0") On Nov 20, 11:26*pm, Bandit wrote: I have a very simple worksheet with formulas. *Here is what I have: ColumnB * * * * * * *ColumnC * * * * * * * * *ColumnD Sales Amt * * * * * *Sales Return * * * * * * Net Sales $591518.00 * * * * *$12638.00 * * * * * * * *$578880.00 My Formula for calculating Column D is: =IMSUB(B4,C4). *Column B & C shows the $ sign. *When the calculation for Column D appears it does not have the dollar sign. *The entire worksheet is formatted for currency with two decimals. *I checked the individual cell and it is also formatted for currency with two decimals. *What am I missing? *This is a school assignment. Thanks The -- Bandit |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formating cell
Why are you using IMSUB(), which "Returns the difference of two complex
numbers in x + yi or x + yj text format" (See XL Help)??? Since IMSUB returns text, number format won't affect the value. But I'm curious as to what imaginary currency you're using? In article , Bandit wrote: I have a very simple worksheet with formulas. Here is what I have: ColumnB ColumnC ColumnD Sales Amt Sales Return Net Sales $591518.00 $12638.00 $578880.00 My Formula for calculating Column D is: =IMSUB(B4,C4). Column B & C shows the $ sign. When the calculation for Column D appears it does not have the dollar sign. The entire worksheet is formatted for currency with two decimals. I checked the individual cell and it is also formatted for currency with two decimals. What am I missing? This is a school assignment. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formating cell
Thanks for the response. My daughter is taking an excel class. It is
self-paced and very little classroom time. Or so I am told... Anyway, this is the 2nd part of an assignement. She asked me for help because she was having this problem. I have used excel many times in years past, but not an expert by any stretch of the imagination. I picked up just from where she left off to try to resolve this issue. Since I posted, I have noticed that this may be just the tip of the problem rather then the entire problem. The assignement states for her to use the forumlas taught in this chaper so I assume I am going to have to go review the chapter to see if she is using the correct formulas to begin with. I started at the $$$ problem because that is what she said she needed help with. But now I think it is a bigger problem. Now I need to figure out the problem so I can get her to work through it. Thanks though, I will post if I need additional assistance. Thank you -- Bandit "JE McGimpsey" wrote: Why are you using IMSUB(), which "Returns the difference of two complex numbers in x + yi or x + yj text format" (See XL Help)??? Since IMSUB returns text, number format won't affect the value. But I'm curious as to what imaginary currency you're using? In article , Bandit wrote: I have a very simple worksheet with formulas. Here is what I have: ColumnB ColumnC ColumnD Sales Amt Sales Return Net Sales $591518.00 $12638.00 $578880.00 My Formula for calculating Column D is: =IMSUB(B4,C4). Column B & C shows the $ sign. When the calculation for Column D appears it does not have the dollar sign. The entire worksheet is formatted for currency with two decimals. I checked the individual cell and it is also formatted for currency with two decimals. What am I missing? This is a school assignment. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why are you using IMSUB(), which "Returns the difference of twocomplex
Come off it, she just needs to know to use the =(A1-B1) formula.
On Thursday, November 20, 2008 1:26 PM Bandi wrote: I have a very simple worksheet with formulas. Here is what I have: ColumnB ColumnC ColumnD Sales Amt Sales Return Net Sales $591518.00 $12638.00 $578880.00 My Formula for calculating Column D is: =IMSUB(B4,C4). Column B & C shows the $ sign. When the calculation for Column D appears it does not have the dollar sign. The entire worksheet is formatted for currency with two decimals. I checked the individual cell and it is also formatted for currency with two decimals. What am I missing? This is a school assignment. Thanks The -- Bandit On Thursday, November 20, 2008 1:36 PM JE McGimpsey wrote: Why are you using IMSUB(), which "Returns the difference of two complex numbers in x + yi or x + yj text format" (See XL Help)??? Since IMSUB returns text, number format won't affect the value. But I'm curious as to what imaginary currency you're using? In article , Bandit wrote: On Thursday, November 20, 2008 3:05 PM Bandi wrote: Thanks for the response. My daughter is taking an excel class. It is self-paced and very little classroom time. Or so I am told... Anyway, this is the 2nd part of an assignement. She asked me for help because she was having this problem. I have used excel many times in years past, but not an expert by any stretch of the imagination. I picked up just from where she left off to try to resolve this issue. Since I posted, I have noticed that this may be just the tip of the problem rather then the entire problem. The assignement states for her to use the forumlas taught in this chaper so I assume I am going to have to go review the chapter to see if she is using the correct formulas to begin with. I started at the $$$ problem because that is what she said she needed help with. But now I think it is a bigger problem. Now I need to figure out the problem so I can get her to work through it. Thanks though, I will post if I need additional assistance. Thank you -- Bandit "JE McGimpsey" wrote: On Saturday, November 22, 2008 2:01 PM muddan madhu wrote: try this =3DTEXT(IMSUB(B4,C4),"$0") =A0 =A0ColumnD Sales 78880.00 shows the ignment. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help formating a cell | Excel Worksheet Functions | |||
Formating cell | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
CELL FORMATING | Excel Discussion (Misc queries) | |||
Cell not formating | Excel Discussion (Misc queries) |