Format a concatenation string?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hilton - 19 Jun 2007 09:37 GMT

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

Reply to this Message

Pete_UK - 19 Jun 2007 10:17 GMT

Try this:

=TEXT(A1,"00.0%")&" were recorded"

Hope this helps.

Pete

> Is there a function to format a concatenation string eg
>
[quoted text clipped - 5 lines]
> Thanks
> Hilton

Reply to this Message

Earl Kiosterud - 19 Jun 2007 17:04 GMT

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.

Signature

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...
-----------------------------------------------------------------------

> Is there a function to format a concatenation string eg
>
[quoted text clipped - 5 lines]
> Thanks
> Hilton

Reply to this Message