| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency Format Only Certain Info in cell
I am working on a formula that I need to have certain numbers in the currency
format: The formula I have is ="Prewire "&A1&" $"&A2&CHAR(10)&"Unwired "&B1&" $"&B2 I need to have A2 and B2 setup so they will show as 8.90 instead of 8.9. I have been trying to figure it out in the Custom Cell Field to no avail. How would I set the cells to do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Format Only Certain Info in cell
="Prewire "&A1&" $"&text(A2,"#,##0.00")
&CHAR(10)&"Unwired "&B1&" $"&text(B2,"#,##0.00") Change that format inside the =text() function to something you like. FormulaQuestioner wrote: I am working on a formula that I need to have certain numbers in the currency format: The formula I have is ="Prewire "&A1&" $"&A2&CHAR(10)&"Unwired "&B1&" $"&B2 I need to have A2 and B2 setup so they will show as 8.90 instead of 8.9. I have been trying to figure it out in the Custom Cell Field to no avail. How would I set the cells to do that? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Format Only Certain Info in cell
Thanks.
"Dave Peterson" wrote: ="Prewire "&A1&" $"&text(A2,"#,##0.00") &CHAR(10)&"Unwired "&B1&" $"&text(B2,"#,##0.00") Change that format inside the =text() function to something you like. FormulaQuestioner wrote: I am working on a formula that I need to have certain numbers in the currency format: The formula I have is ="Prewire "&A1&" $"&A2&CHAR(10)&"Unwired "&B1&" $"&B2 I need to have A2 and B2 setup so they will show as 8.90 instead of 8.9. I have been trying to figure it out in the Custom Cell Field to no avail. How would I set the cells to do that? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set 2 currency format in 1 cell?? | Excel Discussion (Misc queries) | |||
| get currency format from souce cell(s) of a formula or referance | Excel Discussion (Misc queries) | |||
| Changing cell format from text to currency | Excel Worksheet Functions | |||
| Format Currency in-cell | Excel Worksheet Functions | |||
| Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
Linear Mode
