Two References with / between

[Guest]

I have a slide show in Power point that I am trying to auto fill with
references from excel. I have everything set up for the first part of the
slide deck, and it looks great. The last page has bullet items that put in
raw data that I have captured in my excel spreadsheet I am going to have the
data in my spreadsheet and link it into the slide. In my excel tab I have
the basic format set up the way I want it to look. I do have one cell set up
to show the data and the next to show the percentage. In the first cell I
want to show the two data points that will be referenced with a slash "/"
between. Is this possible to do in one cell so that it does not think that I
am doing a division formula between the reference points? My thought was to
put in a "/" between two CHOOSE functions.

 

[Guest]

Are we talking maybe:

= A1 & " / " & TEXT(B1,"0.00%")

Jim May

 

[Pete_UK]

If your numbers are something like 23 and 17, then you can just enter
23 / 17 and Excel will accept it as text. However, if the numbers can
be construed (by Excel) as a date with the year missing (eg 3/7), then
they will be converted into a date with the current year assumed - to
prevent this happening you should type an apostrophe before the
numbers, i.e. '3 / 7.

Hope this helps.

Pete

 

[Guest]

This worked out great, Thank You for your assistance.