Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating numbers &"Text" to appear as currency &"Text" in formula
Hi,
There was no prior question to this issue. So I thought this would be a challenge... Using Windows XP with Excel 2003. The content of the cell is: =if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No outstandings"),"") Sample of outcome is You owe me 556677.123 Would like the outcome to be You owe me $556,677.13 Already tried changing cell format to Currency but still appears as sample outcome. Thank you for all responses. PS: A hearty appreaciation if anyone sends me $556,677.13 :D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |