Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and number combined in a cell
If in cell A1 I have "The total as of March 1st was"
And in cell D1 I have a numerical formaula that shows March's total, say $1,438.14877. If I do a formula in cell A1 and say = & D1 I get the result of .... The Total as of March 1st was 1438.14877 How can I get this to show ..... The Total as of March 1st was $1,438 In other words format the number so it has $ and coma and no decimal places? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and number combined in a cell
="The total as of March 1st was " & TEXT(D1,"$0")
Regards Trevor "TimN" wrote in message ... If in cell A1 I have "The total as of March 1st was" And in cell D1 I have a numerical formaula that shows March's total, say $1,438.14877. If I do a formula in cell A1 and say = & D1 I get the result of .... The Total as of March 1st was 1438.14877 How can I get this to show ..... The Total as of March 1st was $1,438 In other words format the number so it has $ and coma and no decimal places? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and number combined in a cell
=a1 & " " & Dollar(d1,0) or if you are putting this in A1, ="The total as of March 1st was " & Dollar(d1,0) You don't want to use text because the comas won't show. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=570918 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and number combined in a cell
TimN Wrote: If in cell A1 I have "The total as of March 1st was" And in cell D1 I have a numerical formaula that shows March's total, say $1,438.14877. If I do a formula in cell A1 and say = & D1 I get the result of .... The Total as of March 1st was 1438.14877 How can I get this to show ..... The Total as of March 1st was $1,438 In other words format the number so it has $ and coma and no decimal places? Thanks! Hi TimN, Try this =A1&" $"&LEFT(LEFT(D1,5)*1,1)*1&","&RIGHT(LEFT(D1,5)*1,3 )*1 oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=570918 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and number combined in a cell
Or maybe better:
="The total as of March 1st was " & TEXT(D1,"£#,##0") Regards Trevor "Trevor Shuttleworth" wrote in message ... ="The total as of March 1st was " & TEXT(D1,"$0") Regards Trevor "TimN" wrote in message ... If in cell A1 I have "The total as of March 1st was" And in cell D1 I have a numerical formaula that shows March's total, say $1,438.14877. If I do a formula in cell A1 and say = & D1 I get the result of .... The Total as of March 1st was 1438.14877 How can I get this to show ..... The Total as of March 1st was $1,438 In other words format the number so it has $ and coma and no decimal places? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |