Two References with / between

  • Thread starter Thread starter Guest
  • Start date Start date
G

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