Format a concatenation string?

  • Thread starter Thread starter Hilton
  • Start date Start date
H

Hilton

Is there a function to format a concatenation string eg

79.5% & " were recorded" comes out as .795 were recorded when using
=cell ("contents", a1) & " were recorded"

Would like it to be 79.5% were recorded. Can anyone help?

Thanks
Hilton
 
Hilton,

SOme possible solutions:

=A1
Format this cell (Format - Cells - Number - Custom - Type box: 0.0% "were recorded"
This will leave the contents of the cell a number, which can be referred to in other
formulas.
You can also use this formatting on A1, if that's useful.

=TEXT(A1, "0.0% ""were recorded""")
This returns text -- the number formatting of the cell will have no effect.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top