| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting a number within a text formula
The following text formula includes a cell address for a number between the
two parts of the text. How would I format the number in currency format - dollar sign and comma for thousands place. Here is the formula with A1 referencing a number: =When the value of the asset is above "&A1&", then depreciate the asset" -- MZ |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formatting a number within a text formula
=When the value of the asset is above "&TEXT(A1,"$#,##0.00")&", then
depreciate the asset" Bob Umlas Excel MVP "MZ" wrote in message ... The following text formula includes a cell address for a number between the two parts of the text. How would I format the number in currency format - dollar sign and comma for thousands place. Here is the formula with A1 referencing a number: =When the value of the asset is above "&A1&", then depreciate the asset" -- MZ |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formatting a number within a text formula
="we need about " & TEXT(A1,"$#,##0.00") & " to start work"
-- Gary''s Student - gsnu201001 "MZ" wrote: The following text formula includes a cell address for a number between the two parts of the text. How would I format the number in currency format - dollar sign and comma for thousands place. Here is the formula with A1 referencing a number: =When the value of the asset is above "&A1&", then depreciate the asset" -- MZ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Formatting Number as Text | Excel Worksheet Functions | |||
| Formatting from Number to Text | Excel Discussion (Misc queries) | |||
| formatting number value to text value in excel | Excel Worksheet Functions | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
