| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a number concatenated with text
Hi there, I have one cell value which is a number, say A1:3.5, and I have formatted the cell so that it shows 3.50. I have another cell that contains text which also includes the number above: ="please pay the amount of " & A1 & " to the account..." But then I lose the formatting (shows "..amount of 3.5 to..." instead of "..amount of 3.50 to..."). How can I force the formatting? thx a lot, jm -- jmwismer ------------------------------------------------------------------------ jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201 View this thread: http://www.excelforum.com/showthread...hreadid=515839 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format a number concatenated with text
="please pay the amount of " & TEXT(A1,"0.00") & " to the account..."
-- Gary's Student "jmwismer" wrote: Hi there, I have one cell value which is a number, say A1:3.5, and I have formatted the cell so that it shows 3.50. I have another cell that contains text which also includes the number above: ="please pay the amount of " & A1 & " to the account..." But then I lose the formatting (shows "..amount of 3.5 to..." instead of "..amount of 3.50 to..."). How can I force the formatting? thx a lot, jm -- jmwismer ------------------------------------------------------------------------ jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201 View this thread: http://www.excelforum.com/showthread...hreadid=515839 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format a number concatenated with text
thx for your help, most appreciated! :) -- jmwismer ------------------------------------------------------------------------ jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201 View this thread: http://www.excelforum.com/showthread...hreadid=515839 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| change custom format number to text | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Number is in a text format | Excel Worksheet Functions | |||
Hybrid Mode
