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
|