View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 66
Default Display "/" (slash) as a character, not as an action (divide)

Concatenate, using &, like:

=A1 & "/" & B1

This makes the result text, not number.

Beege

bobdenver wrote:
I want to have data from worksheet #1 in say cell B6 and also cell C6 display
in worksheet #2, cell B6, as 2 different numbers separated by a slash (/),
which normally means "divide by". To better explain:
Worksheet #1
cell B6=129 Cell C6 = 82
displays on Worksheet #2 in cell B6 as:
129/82

The problem is that the slash is normally used for division.