TEXT Function formatting Examples:

Format a date as 12/31/04:
="Payment is due " & TEXT(A2,"mm/dd/yyyy")
Format a number as currency:
="Amount due: " & TEXT(A3,"$#,##0.00")& " USD"
Format a number as a percentage:
="Your score is " & TEXT(A4,"0.00%")
Format a number as a fraction:
="Hours worked: " &TEXT(A5,"# ?/?")