Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting issue
I have the following formula in one of my cells:
=IF(C5<0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" Calculated value") The values in C4, C5, C6 are all in dollar format but the output doesn't show in dollar format. See below: 7500 Supplied by Marketing - Calculated value is 8800 . Any way to get the format like this: $7,500.00 Supplied by Marketing - Calculated value is $8,800.00 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting issue
Hi,
=IF(C5<0,"$"&C6&" Supplied by Marketing - Calculated value is "&"$"&C4,C4&" ") "Iriemon" wrote: I have the following formula in one of my cells: =IF(C5<0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" Calculated value") The values in C4, C5, C6 are all in dollar format but the output doesn't show in dollar format. See below: 7500 Supplied by Marketing - Calculated value is 8800 . Any way to get the format like this: $7,500.00 Supplied by Marketing - Calculated value is $8,800.00 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting issue
Thanks Eduardo! works fine!
"Eduardo" wrote: Hi, =IF(C5<0,"$"&C6&" Supplied by Marketing - Calculated value is "&"$"&C4,C4&" ") "Iriemon" wrote: I have the following formula in one of my cells: =IF(C5<0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" Calculated value") The values in C4, C5, C6 are all in dollar format but the output doesn't show in dollar format. See below: 7500 Supplied by Marketing - Calculated value is 8800 . Any way to get the format like this: $7,500.00 Supplied by Marketing - Calculated value is $8,800.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting issue | Excel Discussion (Misc queries) | |||
Formatting Issue | Excel Discussion (Misc queries) | |||
CSV formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue ??? | Excel Discussion (Misc queries) |