LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Display "/" (slash) as a character, not as an action (divide)

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the column heading in Excel to display "A" "B" "C Thai New Users to Excel 1 November 30th 07 08:06 PM
%1 appears in "Application used to perform action" when trying to edit a file type [email protected] Excel Worksheet Functions 3 December 7th 06 07:00 PM
"IF" with no "false" action - Using Text Danny@Kendal Excel Discussion (Misc queries) 0 December 9th 05 10:20 AM
"IF" with no "false" action - Using Text Rowan Drummond Excel Discussion (Misc queries) 0 December 9th 05 01:01 AM
"IF" with no "false" action Fred Excel Discussion (Misc queries) 5 December 9th 05 12:06 AM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"