View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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