What happens ? do you get an error message ?
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de SteveO
Envoyé : samedi 26 février 2011 04:06
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Cannot remove rows
MS Excel
Hi friends,
When I enter a 16 digit number in a cell, the last digit become 0. How can I
enter a 16 or more digit number in a cell.
Thanks Regards,
Ashish.
--
--
Some important links for excel users:
1. Follow
what kind of error , excel is giving
On Sat, Feb 26, 2011 at 8:06 AM, SteveO watog...@gmail.com wrote:
MS Excel 2007, Office 7: I consider myself to be power user. I have
a spreadsheet with roughly, 12,000 rows.
I went to delete 120 rows at about row 10,000 and they will not go
away,
if u want to insert row after the subtotal line (i.e u are saying that you
want to insert a blank row between the subtal
line, and the next group.)
1-Right Click below the subtotal row, or on first row of below group
2-Click on insert
3-Select entire row
4-Click ok
If u have any further
Nothing happens. Excel briefly behaves as if it is doing something,
but the rows remain. I tried an experiment where I put values in
ColumnA, and those values were erased, but the blank rows remain.
On Feb 26, 4:33 am, Daniel dcolarde...@free.fr wrote:
What happens ? do you get an error
Hi,
use single quote ' then type 16digit number
'12345678912345678
On Sat, Feb 26, 2011 at 1:31 PM, Ashish Khandelwal 4everash...@gmail.comwrote:
Hi friends,
When I enter a 16 digit number in a cell, the last digit become 0. How can
I enter a 16 or more digit number in a cell.
Thanks
XL has a specification limit of 15 decimal digits of precision (see
Help, Specifications). There's nothing you can to in XL itself to
extend the precision. There are a few add-ins around that you can Google
that claim to give up to 200 decimal digits of precision, but I haven't
tried any of them.
Thank you Rana, for your kind support. Is it possible to accomplish this with a
macro as I hane many rows to deal with?
Thanks
Dave
From: excel-macros@googlegroups.com
To: excel-macros@googlegroups.com
Sent: Sat Feb 26 01:45:23 2011
Subject: Re:
Can you copy the data into a blank workbook and try with this new one ?
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de SteveO
Envoyé : samedi 26 février 2011 13:01
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$
Dear All Experts,
I have LAN in my office and want to type in a excel file (Example : abc.xls)
data. Can other person type in same file entering data like Multi User.
Plz give me tips
awaiting your positive responce.
Regards
Sajid Memon
--
Another way,
Do filter on database select all visible cells (Alt + ;) then insert row,
it will insert row before all Sub Total's lines
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of
Hi All,
I am trying to construct chart with series selected from a table with only
selected series to be represented in chart.
I tried using check-box for every series but the legend still reflects all
the series (including not selected series). i Hope there is a better way to
handle this.
I
Dear members,
Thanks for all your contribution to group. I am very happy to see the great
engagement in the group.
For me its very important to know what you feel about the group, So that I
can take any action or initiative on the basis of your feedback.
This is an anonymous survey , so feel
This is excellent. Thank you for your help.
John
On Thu, Feb 24, 2011 at 11:07 PM, Rohan Young rohan.j...@gmail.com wrote:
Hi,
see the attachment if it help
thanks regds,
ROHAN
On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith johnasmit...@gmail.comwrote:
Your kind help please.
I
How do you insert a sample fine to the inital discussion message?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
I'm also trying it insert a row, but in my example, I want to insert
in after the SubTotal after using the subtotal function adding the
blank row after the subtotal line. How would you modify the macro in
your example to accomplish this?
Dave
On Feb 26, 12:44 am, Mahesh parab mahes...@gmail.com
write a mail to excel-macros@googlegroups.com and attach your sample file
On Sun, Feb 27, 2011 at 2:27 AM, Diamond Dave dpehr...@walbro.com wrote:
How do you insert a sample fine to the inital discussion message?
--
17 matches
Mail list logo