Thread: Display "/" (slash) as a character, not as an action (divide)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Display "/" (slash) as a character, not as an action (divide)
Try: =Sheet1!B6&"/"&Sheet1!C6
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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.
Reply With QuoteReply With Quote