Combining Text and formula
I am trying to combine and formula with text. I have a link to another cell
which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
Combining Text and formula
='Write Time Capacity'!$D$20&" % hours"
-- David Biddulph "Mitchell" wrote in message ... I am trying to combine and formula with text. I have a link to another cell which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
Combining Text and formula
='Write Time Capacity'!$D$20&"% hours"
-- Hth Kassie Kasselman "Mitchell" wrote: I am trying to combine and formula with text. I have a link to another cell which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
Combining Text and formula
Thanks for the fast help
"kassie" wrote: ='Write Time Capacity'!$D$20&"% hours" -- Hth Kassie Kasselman "Mitchell" wrote: I am trying to combine and formula with text. I have a link to another cell which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com