Hi there,
Sorry if this was discussed elsewhere: I didn't find the thread then.
Sheet 1 has a value - eg, A1 = 0.743288657
In sheet 2, I want the figure from A1 to be displayed as part of a sentence. The sentence should read: "Occupancy is up 74.3% on last year"
When I do: ="Occupancy is up "&sheet1!A1&" on last year" it obviously just grabs the figure from A1. How can I format this?
Thanks for your help,
Leo
Hi
Try this:
=CONCATENATE("Occupancy is up ",ROUND(Sheet1!A1*100,1),"% on last year")
Click *, if my suggestion helps you. Have a good day!!
In sheet 2 format as "Occupancy is up " 0% " on last year" with the formula in the cell =Sheet1!A1
you use the text() function,this will display a number as text in the desired format
="Occupancy is up "&text(sheet1!A1,"0.0%")&" on last year"
Last edited by martindwilson; 06-11-2012 at 05:45 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Wonderful!
Thank you all. Very much!
Leo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks