Tim Grollman
Board Regular
- Joined
- Feb 24, 2002
- Messages
- 129
Hi,
I am trying to write a formula which will pick up the contents of a few cells and combine them to give me a result like this
FRANCE to EGYPT (7000 Down, 34%)
I can do everything except the 34%. That is formatted as % in its own cell, but when I grab it for this formu;la it reverts to 0.338123 etc. I can round it to two decimal places, in which case it picks up 0.34, but I can't make it show the number as 34% in my output. That is unless i go down the list overwriting with '34% and there are a lot of them. How can I make Excel see the 34% as a piece of text? If I change the format of the cell to Text it turns it to 0.34 for me.
Tim
I am trying to write a formula which will pick up the contents of a few cells and combine them to give me a result like this
FRANCE to EGYPT (7000 Down, 34%)
I can do everything except the 34%. That is formatted as % in its own cell, but when I grab it for this formu;la it reverts to 0.338123 etc. I can round it to two decimal places, in which case it picks up 0.34, but I can't make it show the number as 34% in my output. That is unless i go down the list overwriting with '34% and there are a lot of them. How can I make Excel see the 34% as a piece of text? If I change the format of the cell to Text it turns it to 0.34 for me.
Tim