Concatenate formating

  • Thread starter Thread starter dr_johns
  • Start date Start date
D

dr_johns

Anyone know how to format a number within a string created
from text and cell references, in which the number is the
result of a cell reference within the concatenate function?

Experienced, but Stumped
 
Do you mean

="Amount is " & Text(A3,"#,##0.00")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

Thanks for your reply! Your idea works although I had to
go get familiar with the Text function
I encorporated in into my original formula and it works
fine.

Great. Thanks.
 
Back
Top