| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a number as accounting in a text reference.
Hello and thank you for your help!
I have a simple task but can't find the solution, best shown by example. A1=25.00 or 25 or $25.00 B1=The price is& A1. Result: The price is 25. Desired Result: The price is $25.00 I've tried various TEXT functions to no avail. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format €“ accounting symbols | Excel Discussion (Misc queries) | |||
| Convert number to text with proper accounting for Cheque Printing | Excel Discussion (Misc queries) | |||
| Custom number format - Accounting | Excel Worksheet Functions | |||
| How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
| Accounting Style Number Button | Excel Worksheet Functions | |||
Threaded Mode
