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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a number as accounting in a text reference.
Hi,
By far the simplest solution is to format B1 as currency but you seem to have tried TEXT options so if that is what you want try =TEXT(A1,"$0.00") Mike "Pradhan" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a number as accounting in a text reference.
"Pradhan" wrote:
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 Set B1 to: ="The price is " & TEXT(A1,"$0.00") Use "$#.00" if you would prefer that values less than $1 appear as $.12 instead of $0.12. (I prefer the latter.) Use "$#,##0.00" is you would like values of $1000 and more to appear as $1,234.56 instead of $1234.56. I've tried various TEXT functions to no avail. In the future, show us some examples. It might be educational for you to know what was wrong. ----- original message ----- "Pradhan" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a number as accounting in a text reference.
They all worked. Thanks to you all.
"JoeU2004" wrote: "Pradhan" wrote: 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 Set B1 to: ="The price is " & TEXT(A1,"$0.00") Use "$#.00" if you would prefer that values less than $1 appear as $.12 instead of $0.12. (I prefer the latter.) Use "$#,##0.00" is you would like values of $1000 and more to appear as $1,234.56 instead of $1234.56. I've tried various TEXT functions to no avail. In the future, show us some examples. It might be educational for you to know what was wrong. ----- original message ----- "Pradhan" wrote in message ... 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. |
Reply |
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 |