| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate in a Cell (&) and working with the numbers.
I have this function on E1,
=TEXT(B1-A1),"$ #,##0.00")&" - "&TEXT(D1/C1),"0.00%") I cannot work with the numbers that E1 provides because they are formatted as text. Is there a way to format the numbers in two different ways ($,%), just like my function, but to actually be able to work with these?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate Formula not working | Excel Discussion (Misc queries) | |||
| Concatenate with Line Feed not working | Excel Discussion (Misc queries) | |||
| Concatenate function not working for me | Excel Discussion (Misc queries) | |||
| Working with range of numbers in a cell and searching same | Excel Discussion (Misc queries) | |||
| Working with range of numbers in a cell and searching same | Excel Worksheet Functions | |||
Threaded Mode
