Bug? Multiple values in merged cells

I found that merged cells can contain multiple values.

Steps to reproduce:

Type 1,2,3,4 in a1:d1
type sum(a1:d1) in e1

Select a1:b1 and merge
Warning : MultipleData, overwrite?
Say yes to merge

Select the merged a1:b1 cells
Copy
Select c1
PasteSpecial Formats

No warning.. no overwrite.

c1:d1 are now merged
BUT d1 still contains a value... 
and the SUM of a1:d1 = 8 !!

Also happens with FormatPainter etc
Behaviour observed in xl97,xlXP and xl2003

Error checking will find no fault in the sheet...
and you can spend ages to find out WHY your cross
sums dont match!

(although now that i found this behaviour I'll might
have some use for it...)


-- 
keepITcool

|  www.XLsupport.com  |  keepITcool chello nl  |  amsterdam

0
xrrcvgpbby (46)
11/21/2004 10:42:29 AM
excel.misc 78881 articles. 5 followers. Follow

14 Replies
712 Views

Similar Articles

[PageSpeed] 43

On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay> wrote:

>
>I found that merged cells can contain multiple values.
>
>Steps to reproduce:
>
>Type 1,2,3,4 in a1:d1
>type sum(a1:d1) in e1
>
>Select a1:b1 and merge
>Warning : MultipleData, overwrite?
>Say yes to merge
>
>Select the merged a1:b1 cells
>Copy
>Select c1
>PasteSpecial Formats
>
>No warning.. no overwrite.
>
>c1:d1 are now merged
>BUT d1 still contains a value... 
>and the SUM of a1:d1 = 8 !!
>
>Also happens with FormatPainter etc
>Behaviour observed in xl97,xlXP and xl2003
>
>Error checking will find no fault in the sheet...
>and you can spend ages to find out WHY your cross
>sums dont match!
>
>(although now that i found this behaviour I'll might
>have some use for it...)

I just went through the steps you outlined above.

E1 initially showed '10'

After going through the steps, E1 now shows a '2'.

In other words, I could not reproduce your problem on my system:

Windows XP Pro SP2; Excel 2002 SP3


--ron
0
ronrosenfeld (3122)
11/21/2004 11:40:23 AM
Yes, and merge cells can also contain multiple formats.

Sub test1()
With [a1:b2]
..MergeCells = True
'.Merge
For i = 1 To 4
..Cells(i).Value = i
..Cells(i).Interior.ColorIndex = i + 2
Next
  ''look first then manually or prog' unmerge
  ''four colour formats recovered ?
'.MergeCells = False
'.UnMerge
End With
End Sub

Above applies formats after merging. But I've also had situation where Merge
is done after formats have been applied, formats of the "other" cells
retained but hidden. At the moment I can't seem to recreate but I'm sure it
can occur. For my purposes this scenario can be problematic when polling
formatted cells.

There can also be a difference between
rge.Merge  vs  rge.MergeCells = False

Regards,
Peter

"keepITcool" <xrrcvgpbby@puryyb.ay> wrote in message
news:xn0dq0ymypbgahj00nkeepitcoolnl@msnews.microsoft.com...
>
> I found that merged cells can contain multiple values.
>
> Steps to reproduce:
>
> Type 1,2,3,4 in a1:d1
> type sum(a1:d1) in e1
>
> Select a1:b1 and merge
> Warning : MultipleData, overwrite?
> Say yes to merge
>
> Select the merged a1:b1 cells
> Copy
> Select c1
> PasteSpecial Formats
>
> No warning.. no overwrite.
>
> c1:d1 are now merged
> BUT d1 still contains a value...
> and the SUM of a1:d1 = 8 !!
>
> Also happens with FormatPainter etc
> Behaviour observed in xl97,xlXP and xl2003
>
> Error checking will find no fault in the sheet...
> and you can spend ages to find out WHY your cross
> sums dont match!
>
> (although now that i found this behaviour I'll might
> have some use for it...)
>
>
> --
> keepITcool
>
> |  www.XLsupport.com  |  keepITcool chello nl  |  amsterdam
>


0
Peter
11/21/2004 12:18:13 PM
maybe my steps were not clear?

Sub ReproBug()

With Range("a1:e1")
 .Clear
 .Value = Array(1, 2, 3, 4, "=sum(a1:d1)")
 With .Cells(1).Resize(, 2)
  .Merge
  .Copy
 End With
 .Cells(3).PasteSpecial xlFormats
End With

End Sub

gives me : 1 merge warning and 8 in e1
(xl97,xlXP,xl2003)



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Ron Rosenfeld wrote :

> On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool"
> <xrrcvgpbby@puryyb.ay> wrote:
> 
> > 
> > I found that merged cells can contain multiple values.
> > 
> > Steps to reproduce:
> > 
> > Type 1,2,3,4 in a1:d1
> > type sum(a1:d1) in e1
> > 
> > Select a1:b1 and merge
> > Warning : MultipleData, overwrite?
> > Say yes to merge
> > 
> > Select the merged a1:b1 cells
> > Copy
> > Select c1
> > PasteSpecial Formats
> > 
> > No warning.. no overwrite.
> > 
> > c1:d1 are now merged
> > BUT d1 still contains a value... 
> > and the SUM of a1:d1 = 8 !!
> > 
> > Also happens with FormatPainter etc
> > Behaviour observed in xl97,xlXP and xl2003
> > 
> > Error checking will find no fault in the sheet...
> > and you can spend ages to find out WHY your cross
> > sums dont match!
> > 
> > (although now that i found this behaviour I'll might
> > have some use for it...)
> 
> I just went through the steps you outlined above.
> 
> E1 initially showed '10'
> 
> After going through the steps, E1 now shows a '2'.
> 
> In other words, I could not reproduce your problem on my system:
> 
> Windows XP Pro SP2; Excel 2002 SP3
> 
> 
> --ron
0
xrrcvgpbby (46)
11/21/2004 12:19:21 PM
Hi
[...]
> >(although now that i found this behaviour I'll might
> >have some use for it...)
> 
> I just went through the steps you outlined above.
> 
> E1 initially showed '10'
> 
> After going through the steps, E1 now shows a '2'.
> 
> In other words, I could not reproduce your problem on my system:
> 
> Windows XP Pro SP2; Excel 2002 SP3

Hi
I could reproduce this behaviour with Excel 97. You could also see the 
difference after unmerging the cells.

Frank
0
frank.kabel (11126)
11/21/2004 12:29:09 PM
I can reproduce in Excel 2003 SP1 and 2000 SP3 under Windows 2000 and 
Excel XP SP2 under Windows Me.

Ron, are you sure you followed the directions correctly?  It seems odd 
that MS would correct in an older version and not in the latest version.

Jerry

Ron Rosenfeld wrote:

> On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay> wrote:
> 
> 
>>I found that merged cells can contain multiple values.
>>
>>Steps to reproduce:
>>
>>Type 1,2,3,4 in a1:d1
>>type sum(a1:d1) in e1
>>
>>Select a1:b1 and merge
>>Warning : MultipleData, overwrite?
>>Say yes to merge
>>
>>Select the merged a1:b1 cells
>>Copy
>>Select c1
>>PasteSpecial Formats
>>
>>No warning.. no overwrite.
>>
>>c1:d1 are now merged
>>BUT d1 still contains a value... 
>>and the SUM of a1:d1 = 8 !!
>>
>>Also happens with FormatPainter etc
>>Behaviour observed in xl97,xlXP and xl2003
>>
>>Error checking will find no fault in the sheet...
>>and you can spend ages to find out WHY your cross
>>sums dont match!
>>
>>(although now that i found this behaviour I'll might
>>have some use for it...)
>>
> 
> I just went through the steps you outlined above.
> 
> E1 initially showed '10'
> 
> After going through the steps, E1 now shows a '2'.
> 
> In other words, I could not reproduce your problem on my system:
> 
> Windows XP Pro SP2; Excel 2002 SP3
> 
> 
> --ron
> 

0
post_a_reply (1395)
11/21/2004 1:41:11 PM
I received a Merge Warning using Excel 2003 sp-1 from Office Pro on Windows 
XP Pro sp-2. Error Checking did not catch it, though.

tj


"Ron Rosenfeld" wrote:

> On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay> wrote:
> 
> >
> >I found that merged cells can contain multiple values.
> >
> >Steps to reproduce:
> >
> >Type 1,2,3,4 in a1:d1
> >type sum(a1:d1) in e1
> >
> >Select a1:b1 and merge
> >Warning : MultipleData, overwrite?
> >Say yes to merge
> >
> >Select the merged a1:b1 cells
> >Copy
> >Select c1
> >PasteSpecial Formats
> >
> >No warning.. no overwrite.
> >
> >c1:d1 are now merged
> >BUT d1 still contains a value... 
> >and the SUM of a1:d1 = 8 !!
> >
> >Also happens with FormatPainter etc
> >Behaviour observed in xl97,xlXP and xl2003
> >
> >Error checking will find no fault in the sheet...
> >and you can spend ages to find out WHY your cross
> >sums dont match!
> >
> >(although now that i found this behaviour I'll might
> >have some use for it...)
> 
> I just went through the steps you outlined above.
> 
> E1 initially showed '10'
> 
> After going through the steps, E1 now shows a '2'.
> 
> In other words, I could not reproduce your problem on my system:
> 
> Windows XP Pro SP2; Excel 2002 SP3
> 
> 
> --ron
> 
0
tjtjjtjt (488)
11/21/2004 2:25:03 PM
That wouldn't necessarily be correcting an older version, it might just be a
'feature' introduced into a later version.

Bob

"Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
news:41A09B2C.1010501@no_e-mail.com...
> I can reproduce in Excel 2003 SP1 and 2000 SP3 under Windows 2000 and
> Excel XP SP2 under Windows Me.
>
> Ron, are you sure you followed the directions correctly?  It seems odd
> that MS would correct in an older version and not in the latest version.
>
> Jerry
>
> Ron Rosenfeld wrote:
>
> > On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay>
wrote:
> >
> >
> >>I found that merged cells can contain multiple values.
> >>
> >>Steps to reproduce:
> >>
> >>Type 1,2,3,4 in a1:d1
> >>type sum(a1:d1) in e1
> >>
> >>Select a1:b1 and merge
> >>Warning : MultipleData, overwrite?
> >>Say yes to merge
> >>
> >>Select the merged a1:b1 cells
> >>Copy
> >>Select c1
> >>PasteSpecial Formats
> >>
> >>No warning.. no overwrite.
> >>
> >>c1:d1 are now merged
> >>BUT d1 still contains a value...
> >>and the SUM of a1:d1 = 8 !!
> >>
> >>Also happens with FormatPainter etc
> >>Behaviour observed in xl97,xlXP and xl2003
> >>
> >>Error checking will find no fault in the sheet...
> >>and you can spend ages to find out WHY your cross
> >>sums dont match!
> >>
> >>(although now that i found this behaviour I'll might
> >>have some use for it...)
> >>
> >
> > I just went through the steps you outlined above.
> >
> > E1 initially showed '10'
> >
> > After going through the steps, E1 now shows a '2'.
> >
> > In other words, I could not reproduce your problem on my system:
> >
> > Windows XP Pro SP2; Excel 2002 SP3
> >
> >
> > --ron
> >
>


0
bob.phillips1 (6510)
11/21/2004 2:32:25 PM
On Sun, 21 Nov 2004 04:19:21 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay> wrote:

>maybe my steps were not clear?
>
>Sub ReproBug()
>
>With Range("a1:e1")
> .Clear
> .Value = Array(1, 2, 3, 4, "=sum(a1:d1)")
> With .Cells(1).Resize(, 2)
>  .Merge
>  .Copy
> End With
> .Cells(3).PasteSpecial xlFormats
>End With
>
>End Sub
>
>gives me : 1 merge warning and 8 in e1
>(xl97,xlXP,xl2003)

I think they were clear.

With your SUB and my setup (Windows XP Pro SP2; Excel 2002 SP3)

after running the SUB, I get the merge warning.  After clicking OK to clear the
warning, A1:B1 has a dotted line around the merged cells and I get a message in
the lower bar "Select destination and press ENTER or choose Paste".  Prior to
doing anything, there is a 1 in A1:B1, and a 3 in C:D1, and an 8 in E1.

After hitting ENTER, or Paste and then <esc>, the dotted line clears, and there
are 1's in the merged cells and a 2 in E1.

However, if I hit <esc>, then there remains a 1 in A1:B1; a 3 in C1:D1 and an 8
in E1.


--ron
0
ronrosenfeld (3122)
11/21/2004 4:40:10 PM
On Sun, 21 Nov 2004 13:41:11 GMT, "Jerry W. Lewis" <post_a_reply@no_e-mail.com>
wrote:

>I can reproduce in Excel 2003 SP1 and 2000 SP3 under Windows 2000 and 
>Excel XP SP2 under Windows Me.
>
>Ron, are you sure you followed the directions correctly?  It seems odd 
>that MS would correct in an older version and not in the latest version.
>
>Jerry

Yes, but also see what happens when running the SUB.  (See a prior post).


--ron
0
ronrosenfeld (3122)
11/21/2004 4:41:27 PM
proves my point, doesn't it?

-- 
keepITcool
|  www.XLsupport.com | keepITcool chello nl | amsterdam


Ron Rosenfeld wrote :

> However, if I hit <esc>, then there remains a 1 in A1:B1; a 3 in
> C1:D1 and an 8 in E1.
0
xrrcvgpbby (46)
11/21/2004 4:47:55 PM
On Sun, 21 Nov 2004 13:41:11 GMT, "Jerry W. Lewis" <post_a_reply@no_e-mail.com>
wrote:

>I can reproduce in Excel 2003 SP1 and 2000 SP3 under Windows 2000 and 
>Excel XP SP2 under Windows Me.
>
>Ron, are you sure you followed the directions correctly?  It seems odd 
>that MS would correct in an older version and not in the latest version.
>
>Jerry

OK, I see what the difference was.  After Paste Special Formats, I hit <enter>
or <paste> per the bottom line (same as in the SUB).  In that case the result
is normal.

However, if I hit <esc> or if I use the Format Painter for a single operation,
then I get the same error as K.




--ron
0
ronrosenfeld (3122)
11/21/2004 4:48:45 PM
the warning message is from the actual merge method.
and you SHOULD get it.

the point is the PASTEVALUE merges cells without the warning
and without deleting the values in the 'non first' merged cells.



-- 
keepITcool
|  www.XLsupport.com | keepITcool chello nl | amsterdam


tjtjjtjt wrote :

> I received a Merge Warning using Excel 2003 sp-1 from Office Pro on
> Windows XP Pro sp-2. Error Checking did not catch it, though.
> 
> tj
> 
> 
> "Ron Rosenfeld" wrote:
> 
> > On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool"
> > <xrrcvgpbby@puryyb.ay> wrote:
> > 
> > > 
> > > I found that merged cells can contain multiple values.
> > > 
> > > Steps to reproduce:
> > > 
> > > Type 1,2,3,4 in a1:d1
> > > type sum(a1:d1) in e1
> > > 
> > > Select a1:b1 and merge
> > > Warning : MultipleData, overwrite?
> > > Say yes to merge
> > > 
> > > Select the merged a1:b1 cells
> > > Copy
> > > Select c1
> > > PasteSpecial Formats
> > > 
> > > No warning.. no overwrite.
> > > 
> > > c1:d1 are now merged
> > > BUT d1 still contains a value... 
> > > and the SUM of a1:d1 = 8 !!
> > > 
> > > Also happens with FormatPainter etc
> > > Behaviour observed in xl97,xlXP and xl2003
> > > 
> > > Error checking will find no fault in the sheet...
> > > and you can spend ages to find out WHY your cross
> > > sums dont match!
> > > 
> > > (although now that i found this behaviour I'll might
> > > have some use for it...)
> > 
> > I just went through the steps you outlined above.
> > 
> > E1 initially showed '10'
> > 
> > After going through the steps, E1 now shows a '2'.
> > 
> > In other words, I could not reproduce your problem on my system:
> > 
> > Windows XP Pro SP2; Excel 2002 SP3
> > 
> > 
> > --ron
> > 
0
xrrcvgpbby (46)
11/21/2004 4:50:41 PM
On Sun, 21 Nov 2004 04:19:21 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay> wrote:

>maybe my steps were not clear?
>
>Sub ReproBug()
>
>With Range("a1:e1")
> .Clear
> .Value = Array(1, 2, 3, 4, "=sum(a1:d1)")
> With .Cells(1).Resize(, 2)
>  .Merge
>  .Copy
> End With
> .Cells(3).PasteSpecial xlFormats
>End With
>
>End Sub
>
>gives me : 1 merge warning and 8 in e1
>(xl97,xlXP,xl2003)

See my later response to Jerry.  With your initial operation, and with the SUB,
after completing your steps, if I then hit <esc> (and not <enter> or <paste>),
then I can reproduce your feature.

Also, using the format painter in a single operation will reproduce the
problem.  If you use it for a multiple operation (i.e. double click on the
format painter), then you have the opportunity to hit <enter> and get the
merge.

HOWEVER, and this would seem to be ANOTHER bug, if you do the PASTE FORMAT on a
merged cell, and if you hit <enter> or <paste> when done, C1:D1 do merge, but
the VALUE from A1 gets copied over into C1.




--ron
0
ronrosenfeld (3122)
11/21/2004 4:54:16 PM
On Sun, 21 Nov 2004 02:42:29 -0800, "keepITcool" <xrrcvgpbby@puryyb.ay> wrote:

>
>I found that merged cells can contain multiple values.
>
>Steps to reproduce:
>
>Type 1,2,3,4 in a1:d1
>type sum(a1:d1) in e1
>
>Select a1:b1 and merge
>Warning : MultipleData, overwrite?
>Say yes to merge
>
>Select the merged a1:b1 cells
>Copy
>Select c1
>PasteSpecial Formats
>
>No warning.. no overwrite.
>
>c1:d1 are now merged
>BUT d1 still contains a value... 
>and the SUM of a1:d1 = 8 !!
>
>Also happens with FormatPainter etc
>Behaviour observed in xl97,xlXP and xl2003
>
>Error checking will find no fault in the sheet...
>and you can spend ages to find out WHY your cross
>sums dont match!
>
>(although now that i found this behaviour I'll might
>have some use for it...)

There are some MSKB articles referencing XL97 and 2000 with regard to problems
with Paste Special and Format Painter and Merged cells.

It sounds as if they have not fully developed this "feature" :-).


--ron
0
ronrosenfeld (3122)
11/21/2004 5:04:25 PM
Reply:

Similar Artilces:

How to diffrentiate Text & number from a single cell????
Hi ther guyz............i a have small problem with the execl sheets........... my problem is e.g. i have alot of cells with a number and some text in it........and they both are in one/single cell (e.g. "878 queen st" in A1)....now what i want is to remove let's say "queen st" from each cell so that there is only number left in it.....................i cannot figure out any formula........if there is any..............need help imediately -- pack_card2000 ------------------------------------------------------------------------ pack_card2000's Profile: http://www...

Delete cell contents while retaining formulas
I want to delete cell contents from cells I select without deleting the formulas. How do I accomplish this? Thanks in advance.. Hi - select your range - hit F5, click 'Special' and check 'Constants' - now hit the DEL key -- Regards Frank Kabel Frankfurt, Germany "Dave A." <cyberayk@excite.com> schrieb im Newsbeitrag news:Oo4ybUJ2EHA.1144@TK2MSFTNGP09.phx.gbl... > I want to delete cell contents from cells I select without deleting the > formulas. How do I accomplish this? > > Thanks in advance.. > > ...

Protected cells and grouping
I have a spreadsheet that I am using grouping to expend and compress associated lrows of date. Within the group I want to protect some rows. However, I find that when I set this up the grouping no longer functions. Is there a way to set this up so I continue to expand or compress the group and still protect some of the rows of data within the group? Thanks, --Jim Have you thought of using a userform with mutitabs etc to view the sheet.? http://www.geocities.com/excelmarksway "JimS" wrote: > I have a spreadsheet that I am using grouping to expend and compress > asso...

Copy Cells with VBA
Hello, I'd like a VBA macro that would copy in row C4 of worksheet A the content of row E11 of worksheet B. Is that possible ? Regards, Hi Jef If both workbooks are open try this I think you mean a range instead of a row? Workbooks("A.xls").Sheets("sheet1").Range("C4").Value = _ Workbooks("B.xls").Sheets("sheet1").Range("E11").Value -- Regards Ron de Bruin http://www.rondebruin.nl "Jeff" <Jeff@discussions.microsoft.com> wrote in message news:637A2067-D2D9-4607-B2D2-B03884429075@microsoft.com... > He...

Deleting 1 folder across multiple Mailboxes
We created a duplicate junk mail folder and want to delete it across multiple mailboxes. Is there a utility that will do this or do we need to open each mailbox individually? We have 1200 mailboxes. Thank you Exmerge.exe will do this...it is available at download.microsoft.com. "Griff" <Griff@discussions.microsoft.com> wrote in message news:886F1600-5F60-43F1-9F64-968C2F0FB115@microsoft.com... > We created a duplicate junk mail folder and want to delete it across > multiple > mailboxes. Is there a utility that will do this or do we need to open > each &...

Deleting N/A value in a spreadsheet with V-Look Up
Hi I have a large spreadsheet of Data that contains a Vlook up to anothe sheet. I need to sum the figures however the V-Look up is returnin some N/A values which the autosum doen't recognize. How do I delet these or make them equal to zero? thanks -- JOConno ----------------------------------------------------------------------- JOConnor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1661 View this thread: http://www.excelforum.com/showthread.php?threadid=31482 Hi you may change your formulas to =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)) or for...

blank cells #4
How do I copy and paste...and OMIT blank cells.. Larry Hi Try this: Select the range of data, click Edit>Goto>Special and select Contants; non-blank cells will be selected this way. Next, carry out normal copy and paste procedures. >-----Original Message----- >How do I copy and paste...and OMIT blank cells.. > >Larry >. > ...

Chart with merged rows
Another question for EXCEL gurus ! I have a chart with 56 rows (corresponding to 56 weeks in a year), each of which is composed of merging 7 rows (corresponding to 7 days/week). How can I get a graph with the values in these merged columns ? Selecting these and clicking the chart icon does not produce anything ! X-axis C, Y-axis - D -------------------------------------------------------------------------------- A B C D --------------------------------------------------------------------------------- 13. Aug. Sunday ...

Unable to Sum cells in Excel
Hello, I am having issues trying to use the SUM function to autosum a couple of cells that have If functions within them. I am trying to do the following: In Q12 I am trying to get the Sum of N12, O12 and P12. I have only tried =SUM(N12:P12) as the function formatting the cell as text, general, numeric etc but the total always ends up being 0.00, I never get an addition of the values in the other cells. Each of the N, O and P cells has the following function within it, =IF(F12="","",IF(F12>=90%,"5",IF(F12>=85%,"4",IF (F12>=78%,"...

pasting 1 cell into merged cells
Is this possible at all? I get an error: cannot change part of a merged cell. thanks, dominique Hi this is one of the drawbacks of merged cells. Therefore try to avoid these kind of formating -- Regards Frank Kabel Frankfurt, Germany Dominique Schroeder wrote: > Is this possible at all? > > I get an error: cannot change part of a merged cell. > > thanks, > > dominique You can get around the error message by pasting into the function lin above the worksheet. Look for the fx just above your lettered columns, click just right of the fx in the white line and ...

selecting cells #3
When working with a large group of cells, I find it easier to click the top cell, scroll to the bottom, and click the last cell while holding the shift key down. The problem is, when I want to select a second column of data, I have to select the top cell using the control key, the pull down the cursor manually. Is there a way to select 2 or more non-adjacent columns without having to scroll down using the mouse? Nevermind - figured it out myself. The easiest things are often so obvious they are hard to see. "Wazooli" wrote: > When working with a large group of cells, I...

Merging text files with excel
Hello All. How can I merge several text files with the same format into one Excel sheet in one go ? I am importing them singly but it would be much better to merge them together before opening. Many thanks for any help ! Maybe you can use some old DOS commands. Shell to a command prompt and issue an old DOS command to concatenate the Text files. Windows start button|Run (or flying windows r as a shortcut!) win98: Command WinXP/NT: CMD Go to that folder: C: (to change to that drive) cd\myfolder1\myfolder2\myfolder3 to change to that folder copy *.txt All.Files Ren All.Files All....

zero values become negative notation
1 value of a cell minus another similar value of another cell = a negative value with a negative notation power. Is this a bug? Maybe the two values are not exactly the same. Could this be IEEE round-off error? Chip's clear explanation http://www.cpearson.com/excel/rounding.htm Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/...

Wrap text, Merge cells
I have merged 2 cells in a column, wrapped the text. There are actually 20 rows of data ( sentences) in one cell After the 18th row within that merged cell the data is no longer visible. Is there a limit to how high a cell can be ( mine is at 350, but can be made a whole lot large, not that the data is visible though) or how many "rows" wihin a merged and wrapped cell are possible? Stumped in IN. thanks for any info on this subject A row's height (with or without merged cells) cannot exceed 409. Also, a cell can display only about 1000 characters even though it can hold ov...

popup calendar with multiple months
I currently have popup calender in Excel to fill in cells with the date. I would like to be able to view 3 months at a time How can I change my set up to allow this. ...

Length cell limited ?
It is needed to insert in a combined cell a chain of but of 1500 characters however happens the following thing: although the information is complete in the cell, the chain is visualized partially since in form alone the first 1170 characters appear. It has been to modify the format of the cells but the complete information doesn't appear. Any help will be welcome Mario Why do you need so much information in a single cell? Is it because it's a formula? The way I have found around this problem is to break the formula down into 2 cells resulting in a 1 or 0 and have a third ce...

HELP WITH A MAIL MERGE
http://www.mvps.org/dmcritchie/excel/mailmerg.htm ...

How I can set highlighted active cell in row & colmun cross
I want to set active cell highlighted in row & colmun cross as it was possible in Lotus 123. Is it possible? if yes, how is it? Option Explicit '---------------------------------------------------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) '---------------------------------------------------------------- Cells.FormatConditions.Delete With Target With .EntireRow .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlTop) ...

If formula that looks at multiple cells and values, and then calul
I'm trying to put together a production spreadsheet for mechanical manufacturing that figures out a length of one piece of material based on other dimensions. It's for storm shutter parts and the cut dimensions need to be calculated from the field measures. There are many types of tracks available and the blade length is dependant upon the finish height, track type and structure. I need the formula to look at 5 different cells that may or may not have data for the top track and only use the data from the one that's filled out. Same for the bottom track for a total of 10 ...

Error in Mail Merge when selecting Edit Individual Labels
We are noticing an interesting error when trying to perform a mail merge within CRM and Microsoft Word. We have created a view in contacts and we perform all the typical mail merge functionality using the Labels option. At the end, instead of printing the labels without any edits, we click on “Edit Individual labels” and we get the following error… C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE has encountered a problem and needs to close. We are sorry for the inconvenience. We are on CRM v4 Update Rollup 8 using Outlook 2007 and the CRM Outlook (Online only) client. Has an...

can only see one page of a multiple page publisher file
today can only see the first page of a file in publisher....checked the attributes removed the read only....could not remove from overall i.e. my documents...can pull up on another computer via network and see all....so file appears to be okay...can also print all pages, but can only see and work with page one...HELP.....AND A BIG THANKS TO WHOMEVER!!!! What happens when you try to click on the other pages? Do you have the status bar turned on? (View - Status bar) -- JoAnn Paules MVP Microsoft [Publisher] "CON" <CON@discussions.microsoft.com> wrote in message news:...

VALUES ARE DIFFERENT THAN CALCULATOR
I am figuring my payroll on an Excel spreadsheet. When I enter the formulas, the values are sometimes off by a penny. On my calculator, I have it set to 5/4. How do I get my formulas to come out the same as the calculator? Look in help for the ROUND function Also see link for discussion of rounding issues http://www.cpearson.com/excel/rounding.htm "Jaime" wrote: > I am figuring my payroll on an Excel spreadsheet. When I enter the formulas, > the values are sometimes off by a penny. On my calculator, I have it set to > 5/4. How do I get my formulas to come out...

How to prevent cell reference incrementing
I have an issue with a spreadsheet in that I want a calculation to always use the same cell in a calculation. I have placed the $ signs before the letter and number references and I have even tried defining a name for the cells concerned but as soon as I insert a line above the whole equation is offset which causes problems. Is there a way to totally lock into a certain cell either through using the name or with special characters ? Put the address in a cell as text (let's say in A1) Use =INDIRECT(A1) -- Kind regards, Niek Otten <theresaluff@gmail.com> wrote in message news:...

Can you apply split colour formatting to the same cell?
Hi, I'm looking to apply more than one colour format to the same cell, split diagonally from right to left (one colour being orange, the other being white/uncoloured). I don't want stripes, just two blocks of colour making up the cell background. Slightly bizarre question, I know, but it's for a work diary for a department with colour representing 'busy' and white/uncoloured representing 'available'. As I'm busy for the first half of the day, I want to split the cell in half. At the moment I just have a diagonal line and the whole cell in orange, but wan...

Merging Data into Word and Want Checkboxes (Yes/No data type)
I am trying to merge data from my access database into word. I have several items that are checkboxes in access. How do i get those checkboxes to merge into word so that i see them. Right now they just produce numbers if they are checked or not. Thanks I'm not sure you can do with with a straight mail merge. The following is a snippet of code from one of my applications. The app relies on documents that have already been bookmarked with simple bookmarks (for fields longer than 255 characters), checkboxes (for y/n fields), and textboxes for everything else. The merging is d...