| 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 |
| 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 | |||
Threaded Mode
