Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Very Basic Problem - Merged Cell Equals Contents of a Single Cell

When I make the contents of a merged cell i.e. E1:J1 equal to a single cell
(A1) on the same sheet or from sheet to sheet the merged cells display =A1
and not the content. What am I doing wrong?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Very Basic Problem - Merged Cell Equals Contents of a Single Cell

Hi!

Sounds like the merged cells are formatted as TEXT.

Select the merged cells.
Goto FormatCellsNumber tabselect GENERALOK
While the the merged cell is still selected, press function key F2 then hit
ENTER.

Biff

"jollynicechap" wrote in message
...
When I make the contents of a merged cell i.e. E1:J1 equal to a single
cell
(A1) on the same sheet or from sheet to sheet the merged cells display =A1
and not the content. What am I doing wrong?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Very Basic Problem - Merged Cell Equals Contents of a Single Cell

Could be a couple of things...

#1. Format the cell (E1:J1) as General and then reenter that formula.

#2. Tools|Options|View tab|Uncheck Formulas

#3. You have a leading space in your formula???

I'd bet it was #1.

And you may want a formula like:

=if(a1="","",a1)

Then when A1 is empty, you won't see a 0 in that "receiving" cell.

jollynicechap wrote:

When I make the contents of a merged cell i.e. E1:J1 equal to a single cell
(A1) on the same sheet or from sheet to sheet the merged cells display =A1
and not the content. What am I doing wrong?


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Very Basic Problem - Merged Cell Equals Contents of a Single C

Thanks guys. I new it was a dumb asred question. Merged cells were set to
Text. Changed as instructed and now works fine
Reply
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
Problem with changing cell contents with $ sign MMangen Excel Worksheet Functions 4 December 20th 06 12:22 AM
Cell contents to refrenence cells slowjam4 Excel Worksheet Functions 0 September 7th 06 05:02 PM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Returning Cell Value if someone deletes the contents of a cell mmc308 Excel Worksheet Functions 4 March 31st 06 06:41 PM
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM


All times are GMT +1. The time now is 12:43 PM.

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"