Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the number of decimal places displayed in Excel
How do I change the number of decimal places displayed in Excel when
concantenating m calculation results with text? The normal format options do not work. Example: I want 601.23423423A displayed as 601.23A. <TIA |
#2
|
|||
|
|||
as an example
=TEXT(601.23423423,"0.00")&"A" -- HTH RP (remove nothere from the email address if mailing direct) "Dan" wrote in message ... How do I change the number of decimal places displayed in Excel when concantenating m calculation results with text? The normal format options do not work. Example: I want 601.23423423A displayed as 601.23A. <TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Number Format Issues-Decimal Places | Excel Worksheet Functions |