| Article | Body |
| 3 |
Said Shades in alt.destroy.microsoft on Sun, 18 Mar 2001 19:27:20 -0800;
"T. Max Devlin" <tmax@commercelinks.net wrote in message
news:tm4abtgfsatb2vmeefdretb24uuhn6pudv@4ax.com...
No, Linux people think that exploiting the work of others to make money
is bad, because it is, and that wealth which comes from profiteering is
bad, because it is.
Um... did MS exploit any workers? What works of others? [...]
No, customers and software developers. Not anyone who worked for MS (as
far as this discussion is concerned.) Don't be so pig-headed, and we
might be able to have a discussion here.
Capitalism is all well and good, but you need to
pay much more attention to Mr. Smith's words if you want to use them.
You can't trust the benevolence of the butcher, but in the real world,
you don't have to, because he has competition. If software developers
didn't get themselves so hung up trying to prevent others from competing
by purposefully avoiding interoperability, then the Linux people, who
consider the open source movement the champion of capitalism, and the
profiteers the equivalent of communism, wouldn't have to piss on their
parade.
That isn't the real jist of what Adam Smith was saying. Ayn Rand
stated it pretty clearly in "Atlas Shrugged". [...]
Bwah-ha-ha-ha-ha-ha. So much for your ability to not be pig-headed.
You must have been born that way, to believe that Ayn Rand has anything
informative or worthwhile to say about Adam Smith.
--
T. Max Devlin
*** The best way to convince another is
to state your case moderately and
accurately. - Benjamin Franklin ***
|
| 5 |
Um... what business reason does MS have of putting these products
on Linux or Solaris?
Sale of the products to potential customers who run Linux or Solaris,
perhaps? What business reason does MS have for foregoing those profits,
hmmm? And how well acquainted are you with the details of anti-trust
law?
SQL Server runs only on
NT because MS has no reason to port it to Unix. Why would they?
I thought you said they were a competitive company. Yet they seem to
cringe from even the slightest hint of competition, so much so that even
if they were to make money selling a product, they won't, because it
might reduce the demand for some other of their product (which happens
to enjoy a monopoly). Are you getting this, yet?
I have seen Oracle port to NT and it was not very good (mem leaks, etc).
SQL Server is by far superior from an Admin and developing perspective. You
also may not be aware of this but in many ways large companies liked going
to one company regarding a problem. Too many times if Oracle was screwing
up they would blame it on the OS and vice versa.
Also I do not believe your analysis is correct on "cringing" from
competition. Check out the "Host Integration Service" from MS which allows
you to integrate with CICS, DB2 among other things. Also there have been
ODBC drivers since the dawn of time that allowed you to access Oracle
databases. Besides, as many Linux and Unix people like to mention,
Windows NT Server is not as strong in the server market as they are. SQL
Server and NT are not enjoying a monopoly, just the desktop is and as I said
SQL Server interoperates with many systems. There is no barrier of using it
and if you do not like the OS you can simply use Oracle on your Unix. MS
clients and web services will talk to them too (and CICS and DB2...). You
make statements where MS doesn't interoperate but there are many counter
arguments I can add that says MS works with many products, OS's and
software. XML is just another example.
Where do you see a cost benefit to port it to Unix?
Ah, but the difficulty porting a Win32 program to Unix is entirely
Microsoft fault, you see. Had they not made it so difficult, do you
think they'd then no longer wish to forego those profits? And what
business benefit was there, precisely, in making Win32 so different from
the de facto standard OS?
Well porting from any OS to another is not a simple task. Porting from VMS
to Unix isn't and neither is porting from Win32 to Unix. Your claim that
Unix is a defacto os would probably piss off some old VMS people who thinks
Unix is full of shit. Also the defacto DESKTOP OS at the time was DOS and
OS/2. Win32 came out of the old Windows API built on DOS and borrowed
stuff from OS/2 considering MS developed part of it. All new stuff came in
the OS came from Dave Cutler's group. Thinking that Unix is the center of
the OS universe is maybe why there is so much animosity towards NT. I don't
care as much because I personally think VMS was much better than any other
OS.
There are many OS features that NT added that Unix did not have at the time.
My wife (a Unix and ex-VMS programmer) used to yell at me about how Winsock
had "extra" calls above and beyond the Berkeley spec and she claimed it was
because MS wanted to "change the standard". These extra calls she came to
realize allowed you to develop socket code that support asynchronous IO
better than the Berkeley spec (at that time) had. You may say argh and ugh
over it but it is better and I do not have to use them if I do not want to.
I can stick with Berkeley just fine or check the OS I am running on.
Also my statement wasn't because the port would be too expensive but the
support would be. Supporting software on multiple platform is expensive
at best. MS had no experience with software on the Sun architecture.
Continued support of the Intel architecture seems a better bet for them and
their clients(though I hate it). As I said, I doubt the cost would justify
the sales.
MS did play with Unix in the mid 80's(I think). They owned a chunk of SCO
and it did not do well enough so they stuck with what they knew.
If there was a business
demand to do so I am sure MS would for making money is what the
game is about.
In other words, you have no reason to believe MS would ever act
competitively, but you believe they would.
I think MS HAS and DOES act un-competitively in certain areas. I also KNOW
Oracle and Sun are not strangers to this practice either. MS is a very
easy target to hit but I contend that I have seen with my own eyes some of
Oracle's actions too. Does that make me hate all software comapanies and I
should jump to Open Source. No, it makes me ensure that I am not stupid
enough to put myself in a state where I get suckered. I never like COM for
it would have put me in that state. .NET looks better but the jury is
still out. It runs on SOAP which is becoming a standard so we shall have
to see.
It makes more sense to have a product like SQL Server be accessible from
other OS's.
Why? MS doesn't make money selling other OSes. Aren't they simply
forgoing profits from sale of Windows by making their server accessible
from other OSes?
No. Customers demand that data be accessible from heterogeneous environs.
If they don't they (meaning MS) are screwed. When it makes business sense
to interoperate MS will do it. Otherwise it is 3rd party time.
SQL Server 2000 for example can stream query data in XML.
Any client/server machine can basically get data from it.
And what about should users of non-Windows OSes desire more than "can
basically get data from it"?
Complete interoperability. Do they do it? No. Does MS have good partial
solutions? Yes, and it has gotten much better.
In addition the
DTC of SQL Server can support being part of a two phase commit using
the industry XA standard. Hmmm... does it not make more business sense
to optimize SQL Server on one OS and ensure it is accessible from other
systems? The "run everywhere" mantra so far doesn't work too well IMHO.
Are they selling databases or OSes? The "run everything" mantra so far
doesn't work too well. Period.
They are selling solutions to cutomers. The OS is part of it but there is
so much more than just an OS that a corporation needs to run on. Selling
just a technology only goes so far. Even MS fails at this (COM for example
solved nothing and was a piece of crap). This is what the large
corporations want more than anything else. If I can sell you a product
that will create indexes and smart searches on documents(all formats) on
Unix systems, NT systems, databases and other repositories AND it works
well people will pay through the nose. I am not sure if Unix has it, MS has
a first cut and they are coming out with another that is supposed to be
better (though I heard the installation sucks).
I brought up the DTC example because so many say MS doesn't interoperate and
I have seen where they do more than others. Everyone thinks BG is evil but
for all his money-making he is nothing compared to Ellison in my humble
opinion. Not even close.
Anyway thanks for a good response and for not calling me pig headed again...
|
| 11 |
Thank you Sahak and Andre I never would have succeeded without your
assistance
Andre Croteau <milandre@bigpond.com wrote in message
news:D9wO8.12373$Hj3.40490@newsfeeds.bigpond.com...
Ed,
You could also try this formula:
TEXT(ROUNDUP(MONTH(F17)/3,0),0)&" qtr "&TEXT(YEAR(F17),0)
André
"Ed Wauszkiewicz" <nredwz@yahoo.com wrote in message
news:aedjaq$6adlh$1@ID-78737.news.dfncis.de...
I have a date in cell f17 it's format is 06/14/02 I wish to use this
date
in
cell g5 to indicate the second quarter of the current year that is 2 qtr
02
with the spaces. Is this possible? thanks for checking this post..Ed
|
| 15 |
I have an attendance form and a mileage travel form in excel 2000 format.
Each requires a signature in the appropriate place. I've scanned my
signature as a bitmap and when I paste it in the appropriate line I can't
get rid of the background in that picture.
This signature works fine in WORD but I can't find anything on excel. I've
used the format picture command etc and can't loose the background to make
it transparent so the signature line (actual line) will show through the
background..
Any ideas or help would be appreciated.
THanks
|
| 17 |
That's brilliant, fits perfectly with a little project I have.
Thanks
Andy
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D0A6AF7.4030905@contextures.com...
You can do this on the worksheet:
1. In cell B4, enter the number 1
2. In cell C4, enter the following formula:
=REPT("y",B4*100)
3. Format cell C4 as Monotype Sorts font, and add a border to the cell.
4. Adjust the width of cell C4 to fit the bar.
5. Now, you can enter a percentage in cell B4 and the bar in cell C4
will be adjusted.
Note: for a smaller thermometer, use x, and for a larger one, use z
Peter Kretzman wrote:
Does anyone know a product or available control that will
let me display a visual for percent complete? A simple
horizontal thermometer, filled accordingly, is what I was
thinking of.
Thanks,
PK
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 24 |
Jay,
one way
=A1+B1/24
format as hh:mm
--
Regards,
Peo Sjoblom
"Jay Bonham" <jaybham62@earthlink.net wrote in message news:edPO8.115$6a.9@newsread1.prod.itd.earthlink.net...
Hi.
I'm trying to add hours duration to a start time to get an end time. my
worksheet has a column A with a start time (lets say 4:00 AM) , column B is
hours worked (lets say 4.25 hours) I want column C to add 4.25 hours on to
4:00 AM. (in this case it would be 8:15 AM). This seems like it should be
easy - but i have tried just about everything and have not been sucessful.
Thanks for your help!
|
| 32 |
Hi, Tom.
I want to "set" the custom format for Textbox2.
I am getting the value for Textbox2 from Textbox1. As I exit Textbox1, I
give Textbox2 the value of (1-Textbox1.value). For example, I don't want to
see "0.5" in Textbox2, but ".5". On the Excel spreadsheet, I have a custom
NumberFormat ".0".
I unsuccessfully tried Format for both Value and Text:
Private Sub Textbox2_Change()
Format (tbxTextbox2.Value), ".0"
' Format (tbxTextbox2.Text), ".0"
End Sub
and, also
Private Sub Textbox1_Exit()
Format (tbxTextbox2.value), ".0"
End Sub
Any ideas, Tom? Thanks for your help.
"Tom Ogilvy" <twogilvy@msn.com wrote in message
news:e##sjhVFCHA.1716@tkmsftngp07...
for the most part, it should work.
You have to use the Format command.
If you are filling the textbox from the cell with code, it might be easier
to do
Textbox1.Text = Range("A1").Text
You might want to post the specifics.
Regards,
Tom Ogilvy
Splash <splash@mosquitonet.com wrote in message
news:ugpfmqgvnqmec7@corp.supernews.com...
I have defined a custom "NumberFormat" for my Excel cells. Is there a
way
to make that same custom format apply to a textbox in a userform that
runs
from an Excel macro? (I've asked the VBA group, with no responses).
Thanks, guys.
|
| 47 |
The drop down messages appear from the main toolbar at the top of the
screen, the one that says File, Edit, View, Insert, Format, etc. First one
menu will appear and then another!
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D0D45C1.4030400@contextures.com...
Where do these dropdown menus appear -- in the cell when you select it?
If so, it may be data validation. Choose DataValidation, then click the
Clear All button to remove it.
If that's not it, perhaps you could describe where they appear, and
what's in the menus.
Jay Lathrop wrote:
For no reason at all various drop down menus keep appearing at random.
Makes
it very difficult to enter data. This does not happen on any other
programs.
Would appreciate any thoughts on how to correct the problem.
Jay
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 48 |
hi all,
i have been looking at this for an hour or so, and either
ive lost my marbles or excel is trying to wind me up;
in cell a1 i have value 569212145
in cell a2 i have value 569211864
why does the formula =IF(A1A2,"YES","NO")
give NO????
both cells are format general, is there something
completely glaringly obvious that I am missing?
|
| 52 |
Dear all,
when I write in a cell '1-December' , It automatically changes it to '1-Dec'
. how can I prevent Excel from doing so?
By the way.... I have checked in the format option for cells, and I can
change it to 1-December-2002 , but this is not what I want. I simply want it
to change to 1-December!!
Thanks a million,
Yass :)
|
| 54 |
Cell A2 is probably formatted as text. or the value was entered with a
leading apostrophe. Format the cell as General or another numeric
format, edit the cell (F2) and hit enter.
In article <f36b01c215f9$94863aa0$19ef2ecf@tkmsftngxa01, Dave
<pepperds@lycos.co.uk wrote:
hi all,
i have been looking at this for an hour or so, and either
ive lost my marbles or excel is trying to wind me up;
in cell a1 i have value 569212145
in cell a2 i have value 569211864
why does the formula =IF(A1A2,"YES","NO")
give NO????
both cells are format general, is there something
completely glaringly obvious that I am missing?
|
| 55 |
One possible way,
with your string in A1
=TRIM(SUBSTITUTE(MID(A1,FIND("/",A1)-2,10),".",""))*1
format result as mm/dd/yy
this will work if there is always a space before the date
and the date string itself is not less than 8 characters
Regards,
Peo Sjoblom
Anyone know a quick way to get the date out of a text
string (in a single
cell) such as
"Prices last updated as of 6/17/2002. These are provided
by xxx company"?
A formula or vb solution would suffice.
Thanks for the help !!!
.
|
| 56 |
Hi Yass,
Highlight the cell(s) concerned. Then,
a. Click FormatCells
b. Click 'Number' tab, select 'Custom' under Category
c. Click inside the box for 'Type', enter d-mmmm. Click OK.
hth
Max
-----Original Message-----
Dear all,
when I write in a cell '1-December' , It automatically
changes it to '1-Dec'
.. how can I prevent Excel from doing so?
By the way.... I have checked in the format option for
cells, and I can
change it to 1-December-2002 , but this is not what I
want. I simply want it
to change to 1-December!!
Thanks a million,
Yass :)
.
|
| 60 |
Try:
Format/Cells/Number/Custom d-mmmm
In article <aekmad$ca7@news.emirates.net.ae, Yass
<gol_e_yass@yahoo.com wrote:
Dear all,
when I write in a cell '1-December' , It automatically changes it to '1-Dec'
. how can I prevent Excel from doing so?
By the way.... I have checked in the format option for cells, and I can
change it to 1-December-2002 , but this is not what I want. I simply want it
to change to 1-December!!
Thanks a million,
Yass :)
|
| 62 |
Could you be accidentally hitting the F10 key instead of the equal sign
key?
That would activate the menus.
Jay Lathrop wrote:
The drop down messages appear from the main toolbar at the top of the
screen, the one that says File, Edit, View, Insert, Format, etc. First one
menu will appear and then another!
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D0D45C1.4030400@contextures.com...
Where do these dropdown menus appear -- in the cell when you select it?
If so, it may be data validation. Choose DataValidation, then click the
Clear All button to remove it.
If that's not it, perhaps you could describe where they appear, and
what's in the menus.
Jay Lathrop wrote:
For no reason at all various drop down menus keep appearing at random.
Makes
it very difficult to enter data. This does not happen on any other
programs.
Would appreciate any thoughts on how to correct the problem.
Jay
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 65 |
Thanx!! This works great.
"Peo Sjoblom" <terre08@mvps.org wrote in message
news:f3a501c21600$5a94fdc0$19ef2ecf@tkmsftngxa01...
One possible way,
with your string in A1
=TRIM(SUBSTITUTE(MID(A1,FIND("/",A1)-2,10),".",""))*1
format result as mm/dd/yy
this will work if there is always a space before the date
and the date string itself is not less than 8 characters
Regards,
Peo Sjoblom
Anyone know a quick way to get the date out of a text
string (in a single
cell) such as
"Prices last updated as of 6/17/2002. These are provided
by xxx company"?
A formula or vb solution would suffice.
Thanks for the help !!!
.
|
| 70 |
Hi! I have posted about this problem once before and got
some very useful information as a reply, but I am still
having trouble with making it work. As I am not an
experienced Excel User, I am still trying to learn how all
the functions work. Anyway, here's the problem.
I have 2 files. They are called:
MasterList
DoNotCallList
The Master List is composed of a list of names and phone
numbers. The DoNotCallList is comprised of the same. The
Names in the Lists start in Column A, Row 5. The Numbers
in the Lists start in Column E, Row 5. All the Rows above
are filled with headers and titles for the lists. Both of
the lists have about 110 names and numbers in them, though
this may vary.
What I want to do is use the Match Function to compare the
DoNotCallList to the Master List, and to either flag or
delete any matching numbers. The match will be done using
the phone number, in an xxx-xxx-xxxx format. I have tried
many different variations on the Match Function line to
compare the two, but after I apply the AutoFilter, it
doesn't flag or delete any of the names. To test, I made
sure the fist 10 numbers in each list were duplicates. I
suppose what the trouble is that I am having is getting
the Match Function to compare the two files, and not just
matching something within the same list.
So, what I need help on, is trying to determine the exact
line that I would need to use to compare the two files,
and how I go about applying the line to the lists, and how
to start the filter once it is applied. I am very close,
but there must be something I am doing wrong.
The line I am using a variation on was originally provided
to me as a reply to my first message. It is as follows:
=if(iserror(match(a1,donotcall!$a$1:$a$999,0)),"ok to
call","do not call")
If anyone can help me figure out the exact changes I would
need to make to this line to make it work with my files, I
would be most appreciative. Thanks!
Scott A. Jones
|
| 72 |
I am using XL2000 and Win 98.
I don’t know if this problem is a Macro issue or a general Excel issue, but
I start with this news group.
I get an error message, “Cannot paste that macro formula into a worksheet”
when ever I try to copy and paste a cell or group of cells form one workbook
to another. This only happens in workbooks with macros, however the message
occurs regardless of whether the copied cell is references in a macro. I
can use the Paste Special, Formulas but that loses formatting. The Paste
Special, Values or Paste Special, Formats always yields the error message.
The details of the error say that I have caused an invalid page fault in
Excel.exe. I have seen other posts in which the same error seems to prevent
the file from opening, but this is not my problem.
Any advice appreciated.
Ray Wright
--
raycyn.wright@prodigy.net
|
| 77 |
I need help with exporting to excel from a jsp,I am able
to achieve it using the code
<%@ page contentType="application/vnd.ms-excel" %
But i am facing a problem,which is ,although the desired
table opens up in excel format on the browser ,it
simultaneously opens up a separate excel window also.
I am facing this problem only in IE.
Please help me resolve this problem.
|
| 82 |
"Andy Walawender" <info@globalvillas.com wrote in message
news:f92301c2160f$dc7dfd00$3bef2ecf@TKMSFTNGXA10...
Does anyone known how to / whether it is possible to
insert text into a column of already filled cells. ie
column of cells with numeric values to which I want to add
the string "EUR " for euro in front of the the monetary
values without deleting or clearing the cells.
(There's hundreds of them so doing each one manually is
pretty tedious !!)
Thanks for yr help
Andy
You could create a custom format and use the euro symbol
(this means your numbers will stay as numbers)
alternatively, add a column and do something like:
="EUR "&A1 in the new row, drag it down then copy and paste special: Values
to fix the new column
Doug
|
| 84 |
How about formatting using the Euro symbol?
formatcustom
[$?-1]#,##0.00
or if you want EUR
"EUR"#,##0.00
Regards,
Peo Sjoblom
Does anyone known how to / whether it is possible to
insert text into a column of already filled cells. ie
column of cells with numeric values to which I want to
add
the string "EUR " for euro in front of the the monetary
values without deleting or clearing the cells.
(There's hundreds of them so doing each one manually is
pretty tedious !!)
Thanks for yr help
Andy
.
|
| 85 |
Try selecting the column, right-click, Format Cells,
Number tab, Custom and insert:
"Eur" #,##0_);"Eur" (#,##0)
HTH
Jason
Atlanta, GA
-----Original Message-----
Does anyone known how to / whether it is possible to
insert text into a column of already filled cells. ie
column of cells with numeric values to which I want to
add
the string "EUR " for euro in front of the the monetary
values without deleting or clearing the cells.
(There's hundreds of them so doing each one manually is
pretty tedious !!)
Thanks for yr help
Andy
.
|
| 86 |
1. Select the cells
2. Choose FormatCells
3. On the Number tab, choose Currency or Accounting
4. Select the number of decimal places, and negative number formatting
that you prefer; select $ as the Symbol.
5. Choose the Custom Category
6. In the Type box, replace each $ with:
"EUR "
7. Click OK
Andy Walawender wrote:
Does anyone known how to / whether it is possible to
insert text into a column of already filled cells. ie
column of cells with numeric values to which I want to add
the string "EUR " for euro in front of the the monetary
values without deleting or clearing the cells.
(There's hundreds of them so doing each one manually is
pretty tedious !!)
Thanks for yr help
Andy
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 87 |
I had a typo when converting to my spreadsheet. This formula works well and
will take into account the date format changing and changes to the text
string.
Thanx!!!
"J.E. McGimpsey" <jemcgimpsey@mvps.org wrote in message
news:170620020721318363%jemcgimpsey@mvps.org...
One way (assumes a 4 digit year):
=DATEVALUE(LEFT((MID(A1, FIND("/", A1) - 2, 255)), FIND("%",
SUBSTITUTE(A1, "/", "%", 2)) - FIND("/", A1) + 2))
In article <#IrpunfFCHA.1260@tkmsftngp07, Dave B
<david.bracknell@avmltd.com wrote:
Anyone know a quick way to get the date out of a text string (in a
single
cell) such as
"Prices last updated as of 6/17/2002. These are provided by xxx
company"?
A formula or vb solution would suffice.
Thanks for the help !!!
|
| 88 |
Note: If you have Excel 2000 or Excel 2002, EUR is one of the available
currency symbols, so steps 5 and 6 are not required.
Debra Dalgleish wrote:
1. Select the cells
2. Choose FormatCells
3. On the Number tab, choose Currency or Accounting
4. Select the number of decimal places, and negative number formatting
that you prefer; select $ as the Symbol.
5. Choose the Custom Category
6. In the Type box, replace each $ with:
"EUR "
7. Click OK
Andy Walawender wrote:
Does anyone known how to / whether it is possible to insert text into
a column of already filled cells. ie column of cells with numeric
values to which I want to add the string "EUR " for euro in front of
the the monetary values without deleting or clearing the cells.
(There's hundreds of them so doing each one manually is pretty tedious
!!)
Thanks for yr help
Andy
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 96 |
Is there any way to have a custom format have a hard
return. I want to have the date displayed as ddd
dd/mm/yy, but I don't want the column to be wide, I want
the day of the week to be on one line and the date on the
next line of the cell. Like this:
Mon Tues
6/17/02 6/18/02
Ethan
|
| 103 |
Is there a way to make all empty cells in a column be formatted as a color,
and when they are no longer empty, that that color be removed (and they have
no color)? Thanks, guys.
|
| 105 |
Select Column A, for example, with A1 active (i.e., A1 in the name box
on the formula bar). Choose Format/Conditional Formatting and enter,
using the dropdowns and textbox:
Formula Is =ISBLANK(A1)
Click on Format/Pattern, choose green, then OK, OK.
In article <ugs5t2mk9oc42a@corp.supernews.com, Splash
<splash@mosquitonet.com wrote:
Is there a way to make all empty cells in a column be formatted as a color,
and when they are no longer empty, that that color be removed (and they have
no color)? Thanks, guys.
|
| 127 |
Hello!
I'm creating a excel spreadsheet to import information
into a SQL Server Database. I've got a few columns that
I've used functions to create some of the data. Now here's
my question:
Is there a way to copy that value that's produced by a
function to another cell, so that it could be imported
into the database. For example, a formula I have on the
spreadsheet is =A3+17, which gives me a value. I'd like to
have that value copied into a cell, so that it could be
imported into the database. Currently the cell hold the
value =A3+17, I want the result, say 20, not the actual
function =A3+17 in another cell so I can DTS it into my
database.
I hope this has made some sense.
Thanks,
Erica
|
| 128 |
Highlight the column
format, conditional formatting
cell value is equal to 0
format, patterns, choose green
say OK.
Barbara
Splash <splash@mosquitonet.com wrote in message
news:ugs5t2mk9oc42a@corp.supernews.com...
Is there a way to make all empty cells in a column be formatted as a
color,
and when they are no longer empty, that that color be removed (and they
have
no color)? Thanks, guys.
|
| 136 |
I have unusual problem with printing more than one copy of
a spread sheet from excell 2000/2002. When more than one
copy is printed, the first copy prints, however the second
copy prints very large and the formatting is wrecked as
well.
Sr 1 for xp applied and sr2 for 2000 applied. firm ware
on printer is up to date as well. This function works on
any onther printer except the one in question a 5si nx.
Further, this is not a problem in excel off97, I can print
multiple copies in office 97
|
| 139 |
Because you are creating multiple inter-related sets of
data (relational tables) for inventory, invoicing,
payables, and jobs, MS Access is the optimum application
to use. Access has the ability to create data entry and
display forms, as well as reports that provide the
specific management information structure desired.
However, the flat tables in MS Excel, if constructed
properly, can be related using MS Query, and reports can
be generated with VBA Code and Userforms.
-----Original Message-----
Hi all
I work for a small building business in the uk.
We need a program that will moniter all our stock
as well as the the jobs in progress ie:
Moniter stock
Moniter payments in(interim etc)
Moniter payments out
Moniter several ongoing jobs at once
We've have had no luck as yet in our search (Iv'e been on
google all day)
I was wondering if it might be better to MS access or
excel
Any input most welcome
Cheers
Jill
.
|
| 140 |
1. Select the cells that you want to format
2. Choose FormatCells
3. On the Number tab, choose Custom
4. In the Type box, type ddd
5. Hold the Alt key, and on the number keypad, type 0010
6. Type dd/mm/yy
7. On the Alignment tab, choose Wrap Text, click OK
8. You'll have to manually adjust the height of the cells, as Autofit
doesn't seem to work with this formatting.
Ethan wrote:
Is there any way to have a custom format have a hard
return. I want to have the date displayed as ddd
dd/mm/yy, but I don't want the column to be wide, I want
the day of the week to be on one line and the date on the
next line of the cell. Like this:
Mon Tues
6/17/02 6/18/02
Ethan
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 147 |
Is there an echo??
- Jon
In article <3D0E5CB4.BCF0639C@msn.com, ec35720@msn.com says...
How about this?
You keep the date in a column (hidden??) and then use a formula that formats
it
and wraps it the way you like:
=TEXT(A1,"ddd")&CHAR(10)&TEXT(A1,"mm/dd/yyyy")
ethan wrote:
After playing with it some more, I still have the same original problem.
The width of the columns is determined by the format of the date as if the
hard return was not there. So even though the format looks correct, if I
shrink the column width down so that it is the width of just the date, I
get
####. This makes the sheet too wide to fit on the page.
Ethan
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D0E4989.3050501@contextures.com...
1. Select the cells that you want to format
2. Choose FormatCells
3. On the Number tab, choose Custom
4. In the Type box, type ddd
5. Hold the Alt key, and on the number keypad, type 0010
6. Type dd/mm/yy
7. On the Alignment tab, choose Wrap Text, click OK
8. You'll have to manually adjust the height of the cells, as Autofit
doesn't seem to work with this formatting.
Ethan wrote:
Is there any way to have a custom format have a hard
return. I want to have the date displayed as ddd
dd/mm/yy, but I don't want the column to be wide, I want
the day of the week to be on one line and the date on the
next line of the cell. Like this:
Mon Tues
6/17/02 6/18/02
Ethan
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
--
Dave Peterson
ec35720@msn.com
|
| 174 |
I've done many compound graphs like you describe. The trick is to create
separate charts embedded on a worksheet. By careful use of formatting,
alignment by snapping to cell intersections and grouping, I manage to get
the desired effect.
In your oscilloscope analogy, you would have 3 differing Y axis and want to
share the X or Time axis. In other words, only the bottom time scale shows.
I often do this by scaling all X axes identically on all charts then
overlapping/hiding the axis for the top graphs. You might think you can
just delete the unwanted axis, but the problem you will continually do
battle with is Excel's distressing tendency to resize the plot area every
time you alter axis formatting. You will want everything *exactly* the same
except the Y axis and perhaps, the series displayed. Hint - no auto
scaling/formatting whatsoever. No auto *anything*.
Basically the procedure is this:
1) Create the bottom chart exactly as you would like to see it.
2) Fix (freeze) the axes by turning autoscaling off.
3) Copy/paste this chart for as many charts as you are going to stack.
4) Alter the Y scaling on the stacked charts as necessary.
5) Lay them out and glue them together (group)
With a little effort, the results can be perfect.
Thomas Bartkus
"Microsoft" <edward@biebel.net wrote in message
news:u8btS6uFCHA.2324@tkmsftngp04...
Hi all:
I have a question that has got me stumped and which I believe cannot done
in
Excel but figured I'd ask to be sure.
I've been asked to construct a chart that has three different scales on
it.
However, the problem is not the multiple scales but the layout that is
being
requested.
Essentially the person requesting the chart wants the bottom third of the
chart done in one scale, the middle third done in a second scale and the
top
third in third scale. The only analogy that I can think of to describe
the
look he would like if from my HS physics days where you have an
oscilloscope
with different meter bands each with its own waveform stacked on top of
each
other.
Anyone ever tried this and does this even sound possible? It didn't
possible to me but you known how it goes when you get the "this should be
relatively simple" requests.
Thanks,
Ed
|
| 175 |
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to numeric,
then I copy/ paste special|values back over the original data. Do this for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT to
be numeric?
Howard
|
| 178 |
Can you loop through each cell in the ranges and make them numeric this way
Sub MakeNumeric()
'Multilpies each cell by 1 to make it numeric
Dim DataRng As Range
Dim cell As Range
Set DataRng = Range("A2:A" & Range("A65536").End(xlUp).Row)
For Each cell In DataRng
cell = cell * 1
Next cell
End Sub
HTH?
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT to
be numeric?
Howard
|
| 179 |
Howard,
copy an empty cell, select your data (source and lookup table), do editpaste special and select add.
That will make them all numeric..
--
Regards,
Peo Sjoblom
"Howard" <hsm@sentech.freeserve.co.uk wrote in message news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to numeric,
then I copy/ paste special|values back over the original data. Do this for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT to
be numeric?
Howard
|
| 182 |
Thank you, but isn't this similar to what I do already. OK its a bit quicker
but still seems a bit of a cheating way to do it. I was hoping there was
some way of setting the data type like you can set the format (the lookup
tables can be quite large)
Howard
"Peo Sjoblom" <terre08@mvps.org wrote in message
news:OaVQcFwFCHA.2672@tkmsftngp13...
Howard,
copy an empty cell, select your data (source and lookup table), do
editpaste special and select add.
That will make them all numeric..
--
Regards,
Peo Sjoblom
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this
for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT
to
be numeric?
Howard
|
| 186 |
Thank you, but this is essentially doing in code what I currently do by hand
just copying down the formula =1*A1 and it would still need to be done with
both the lookup table and any spreadsheets that use it.
Surely there is a way to force cells to have a data type!?
After all, what is the point of having a format command to show text or
numeric if it doesn't really change the data type?
Howard
"Wilson" <jwilson@wickes.com wrote in message
news:uL5oYAwFCHA.2552@tkmsftngp05...
Can you loop through each cell in the ranges and make them numeric this
way
Sub MakeNumeric()
'Multilpies each cell by 1 to make it numeric
Dim DataRng As Range
Dim cell As Range
Set DataRng = Range("A2:A" & Range("A65536").End(xlUp).Row)
For Each cell In DataRng
cell = cell * 1
Next cell
End Sub
HTH?
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this
for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT
to
be numeric?
Howard
|
| 188 |
Change the data type, before you run the macro.
"Howard" <hsm@sentech.freeserve.co.uk wrote in message news:aeo4oe$er2$1@newsg2.svr.pol.co.uk...
Thank you, but this is essentially doing in code what I currently do by hand
just copying down the formula =1*A1 and it would still need to be done with
both the lookup table and any spreadsheets that use it.
Surely there is a way to force cells to have a data type!?
After all, what is the point of having a format command to show text or
numeric if it doesn't really change the data type?
Howard
"Wilson" <jwilson@wickes.com wrote in message
news:uL5oYAwFCHA.2552@tkmsftngp05...
Can you loop through each cell in the ranges and make them numeric this
way
Sub MakeNumeric()
'Multilpies each cell by 1 to make it numeric
Dim DataRng As Range
Dim cell As Range
Set DataRng = Range("A2:A" & Range("A65536").End(xlUp).Row)
For Each cell In DataRng
cell = cell * 1
Next cell
End Sub
HTH?
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this
for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT
to
be numeric?
Howard
|
| 197 |
Just a question and guesses:
Does excel blow up (with the same error) with any other workbook? If yes, then
it's probably not this workbook.
If no, then maybe the workbook is corrupted (like Dave suggested).
I've had luck using xl2002 opening files that both xl97 and xl2k couldn't open.
Sometimes formatting was lost, but the data/formulas/macros were there.
Other people have reported that Sun's OpenOffice/StarOffice can sometimes open
corrupted excel files. (It used to be between 80-110 meg download. I looked
and decided that it's too big for my puny modem!)
Not-for-free StarOffice.
/software/download/desktop_app.html
Free version
/dev_docs/source/1.0.0/index.html
IrelandA wrote:
Dear All
I have got a 3MB worksheet which I cannot open. When I try to open it, I get
the following dialogue box:
===================================
Application Error
The instruction at "0x30099749f" referenced memory at "0x00000002". The
memory could not be "read".
Click on OK to terminate the application.
Click on Cancel to debug the application.
===================================
Even if I click on "Cancel", it doesn't open Excel, so I can't view the
spreadsheet at all.
Any help/advice gratefully received...
Regards
Alistair
--
Dave Peterson
ec35720@msn.com
|
| 201 |
You could perhaps, try using "helper" columns.
For example, if your Vlookup formula is:
=Vlookup(A1,C1:E100,2,0)
Change it to
=Vlookup(B1,C1:E100,2,0)
Where B1 contains the formula
=A1*1
Using the same concept, pre-establish a column with a similar formula to
take care of the look-up array of your imported data.
HTH
RD
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo4fe$ceh$1@newsg4.svr.pol.co.uk...
Thank you, but isn't this similar to what I do already. OK its a bit
quicker
but still seems a bit of a cheating way to do it. I was hoping there was
some way of setting the data type like you can set the format (the lookup
tables can be quite large)
Howard
"Peo Sjoblom" <terre08@mvps.org wrote in message
news:OaVQcFwFCHA.2672@tkmsftngp13...
Howard,
copy an empty cell, select your data (source and lookup table), do
editpaste special and select add.
That will make them all numeric..
--
Regards,
Peo Sjoblom
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers
and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the
lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like =
1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this
for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display
FORMAT
to
be numeric?
Howard
|
| 204 |
If your VLOOKUP is of the exact-match type, you might want to have a look at
a thread that discusses the issue you rise:
/board/viewtopic.php?topic=10915&forum=2
Aladin
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT to
be numeric?
Howard
|
| 210 |
You could use INDEX instead (array-entered: Ctrl+Shift+Enter)
=INDEX($I$1:$I$18,MATCH(A1*1,$H$1:$H$18*1,0))
where the values to match are in column I and the value to be returned
is in column H.
If it doesn't find the value it will return an #N/A error.
Howard wrote:
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to numeric,
then I copy/ paste special|values back over the original data. Do this for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT to
be numeric?
Howard
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 213 |
Correction:
where the values to match are in column H and the value to be returned
is in column I.
Debra Dalgleish wrote:
You could use INDEX instead (array-entered: Ctrl+Shift+Enter)
=INDEX($I$1:$I$18,MATCH(A1*1,$H$1:$H$18*1,0))
where the values to match are in column I and the value to be returned
is in column H.
If it doesn't find the value it will return an #N/A error.
Howard wrote:
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this
for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display
FORMAT to
be numeric?
Howard
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 215 |
Chip Pearson has information on his web site that will help you find and
tag duplicates. Combine your lists on one sheet, then use one of Chip's
suggestions.
/excel/duplicat.htm#TaggingDuplicates
jvoortman wrote:
when I have a "potential" customer list in excel, with
companies name in column1, and street address in column 2,
and city in column 3, and province in column 4, and postal
code in column 5,and phone number in column 6, and fax
number in column 7, and watts number in column 8, email,
in 9, and web url in column 10.
Now I would like to merge two different lists with the
same layouts, but i am afraid that there will be some
duplication (because some companies are listed under
different categories in the yellow pages), and I want to
know if there is a short cut to "pointing
out", "eliminating" the doubles?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 224 |
Hi Otto
Thanks for replying.
I realise that its quite complicated as Excel offers all sorts of
features to scale the page according to print requirements.
And that the geometry requirements of the screen is quite different to
a printed page.
I guess I'll just have to print out some kind of grid from a
spreadsheet to work it all out.
Its just a real pain when trying to position objects at a specific
position on the page or set column width and row height to a specific
mm measurement.
In these days of WYSIWYG and DTP etc I hope they may be able to
improve this aspect of printing spreadsheets.
As I am so used to using DTP and CAD I am spoiled by being able to
position text and objects exactly where I want and adjust many fine
aspects of text formatting. I find it a bit archaic in the 21st
century to have to resort to so much trial and error with many test
prints and rulers!
Ian.
"Otto Moehrbach" <ottom@worldnet.att.net wrote in message
news:eFrWdswFCHA.1744@tkmsftngp13...
Ian
What you will get when you print is determined by your printer
driver
more than anything else. To see what you will get, click File -
Print
Preview. HTH Otto
"Ian Roberts" <Ian_Roberts@SPAMOFFBTinternet.com wrote in message
news:aeo4nq$7of$1@nntp-m01.news.aol.com...
Hi
I'm trying to recreate a printed form in Excel.
I'm just getting a bit confused trying to relate the screen row
height
and column width measurements to how it will appear printed on
paper.
Although it might say row height 20.25 (27 Pixels). 20.25 what?
How
many pixels =1cm.
I'm sure this will vary according to screen res - but in order to
speed up the process it would help me to have some guidelines.
I hope its clear what I'm asking for.
Thanks
Ian
|
| 237 |
FWIW
When mapping out new forms, two things that I find help me is:
Making all columns a width of 5,
And placing the "ToggleGrid" icon on my toolbar.
The narrow columns give the form a "graph paper" appearance on the screen,
so you can make small adjustments to text placement, while the ability to
instantly toggle the grid off and on to see how the form will actually
appear, is a big time saver.
HTH
RD
"Ian Roberts" <Ian_Roberts@SPAMOFFBTinternet.com wrote in message
news:aeoe9a$fra$1@nntp-m01.news.aol.com...
Hi Otto
Thanks for replying.
I realise that its quite complicated as Excel offers all sorts of
features to scale the page according to print requirements.
And that the geometry requirements of the screen is quite different to
a printed page.
I guess I'll just have to print out some kind of grid from a
spreadsheet to work it all out.
Its just a real pain when trying to position objects at a specific
position on the page or set column width and row height to a specific
mm measurement.
In these days of WYSIWYG and DTP etc I hope they may be able to
improve this aspect of printing spreadsheets.
As I am so used to using DTP and CAD I am spoiled by being able to
position text and objects exactly where I want and adjust many fine
aspects of text formatting. I find it a bit archaic in the 21st
century to have to resort to so much trial and error with many test
prints and rulers!
Ian.
"Otto Moehrbach" <ottom@worldnet.att.net wrote in message
news:eFrWdswFCHA.1744@tkmsftngp13...
Ian
What you will get when you print is determined by your printer
driver
more than anything else. To see what you will get, click File -
Print
Preview. HTH Otto
"Ian Roberts" <Ian_Roberts@SPAMOFFBTinternet.com wrote in message
news:aeo4nq$7of$1@nntp-m01.news.aol.com...
Hi
I'm trying to recreate a printed form in Excel.
I'm just getting a bit confused trying to relate the screen row
height
and column width measurements to how it will appear printed on
paper.
Although it might say row height 20.25 (27 Pixels). 20.25 what?
How
many pixels =1cm.
I'm sure this will vary according to screen res - but in order to
speed up the process it would help me to have some guidelines.
I hope its clear what I'm asking for.
Thanks
Ian
|
| 238 |
In working with the data further, I find it is just the Age field that
is affecting the macro. Even if I format it as General or Number, I cannot
get the macro to work. If I type the same number into each cell that was
copied there, the macro works fine. ????
"Dave Trop" <dmtrop@cox.net wrote in message
news:53QP8.58314$Hn4.1998285@news1.east.cox.net...
I have recorded a macro to sort, copy and paste text data (Name, Sex,
Age) in a defined dynamic range onto another worksheet. If I actually
type
the data into the defined range, the macro works fine, but if I copy and
paste the data from another workbook into the defined range, the macro
does
not recognize any of the data I have pasted. I have even typed a few sets
of data in, then pasted (and even tried "paste special - values") a few
sets
beneath them, then typed in a few more below those and when I run the
macro,
only the typed-in data is recognized.
Can anyone explain this to me? I thought pasted or pasted-special
data
was treated the same as data that was keyed in directly.
Thank you for any assistance.
-Dave Trop-
dmtrop@cox.net
|
| 278 |
David,
Thanks for the information and links to your excel pages.
Ralph K.
~~~~~~~~~~~~~~~~~~~
-----Original Message-----
Hi Ralph,
You will have to include ISERROR i.e.
=IF(ISERROR(myformula),"error note", myformula)
Might look something like this, since all you need is the
error indicator:
=IF(ISERROR(SEARCH("Inactive",B12,1)),IF(TRIM(B12)
="","","active"),"inactive")
HTH,
, Microsoft MVP - Excel [site changed
Nov. 2001]
My Excel Macros:
/dmcritchie/excel/excel.htm
Search Page:
/dmcritchie/excel/search.htm
"Ralph K." <thermometer@excite.com wrote in message
news:d987c0b7.0206190920.5d224e76@posting.google.com...
I have two columns. Col A is blank. Col B will have
something like:
Alamance Community College
Asheville-Buncombe Community College - Inactive Account
Some cells will say Inactive.
I want to flag those inactive entries by putting the
word "Inactive'
or "Active" in Col A. Here's my formula:
=IF(SEARCH("Inactive",B12,1)<0,"inactive","active")
It does put the word "inactive" in col A, but if the
word "active" is
not present, it gives me this: #VALUE!
Any ideas? The FIND command does not work either.
Thanks.
.
|
| 292 |
You are super. Thanks for all your wonderful code.
"" <dmcritchie@msn.com wrote in message
news:#iu1L46FCHA.2272@tkmsftngp09...
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column < 3 And Target.Column < 5 Then Exit Sub
If UCase(Target.Value) = "XXX" Then _
Target.Value = "'" & Format(Date, "yyyy-mm-dd")
End Sub
Target is a variable name.
See Help -- Index -- ByVal
look at Sub Statement about half way down.
That is about as well as I can answer what Target is
you don't want to substitute activecell for anything there.
The activecell for me would be target.offset(1,0)
since the cursor goes down after entry (tools option)
and if you want to change other cells you want to turn
off EnableEvents
Application.EnableEvents = False
'--ooo coding ooo---
Application.EnableEvents = True
Worksheet Events and Workbook Events
/dmcritchie/excel/event.htm
HTH,
, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: /dmcritchie/excel/excel.htm
Search Page: /dmcritchie/excel/search.htm
"Splash" <splash@mosquitonet.com wrote in message
news:uh19i93l24r367@corp.supernews.com...
Now I'm trying something different. If every time I am in column 4 I
want
to check to see if the text is "XXX", and, if it is, to run a little
code,
do I replace "Text" with "Activecell"?
[That is, in "ByVal Target As Excel.Range", have "ByVal activecell as
Excel.range", and then throughout the code, where Target occurred put
activecell??] If so, this opens up all possiblities.
|
| 297 |
Aladin,
Thank you very much. I didn't know about that site. At least that gives a
one line formula way of doing it.
I'm still astounded that there is not a simple way of setting the data type
from the menu (like one can in access). In a way, being able to change the
FORMAT of a cell is even worse as then you lose any clues that you had to
the cell's data tpye
Thanks to all who replied
Howard
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeoadf$k2t$1@news1.xs4all.nl...
If your VLOOKUP is of the exact-match type, you might want to have a look
at
a thread that discusses the issue you rise:
/board/viewtopic.php?topic=10915&forum=2
Aladin
"Howard" <hsm@sentech.freeserve.co.uk wrote in message
news:aeo1th$mbc$1@newsg3.svr.pol.co.uk...
Hi
I often use vlookup looking up a key composed of 4 digits to find some
associated data.
Sometimes these keys and data are imported from access.
The problem is that sometimes these 4 digits are treated as numbers and
sometimes they are treated as text.
Vlookup fails if the thing you are looking up is text but in the lookup
table it is numeric (or it might be the other way round!) even though
there
is no way to tell the difference visually - especially if the data is
centred so you cannot tell by the default justification.
I get round this by adding a column with formulae something like = 1*A1
where A1 contains the text/numeric digits. This forces them all to
numeric,
then I copy/ paste special|values back over the original data. Do this
for
both source and lookup table and everything is OK.
But.... There must be a better way !!!
How can I force the CONTENTS of a cell as opposed to the display FORMAT
to
be numeric?
Howard
|
| 299 |
Is there any way to have Excel interpret a csv file with a
leading zero field as a character field so that it does
not drop the zero? In the csv file, I have the character
field enclosed in double quotes but it still treats it as
general. I realize I can add the zero back in using the
custom format option but I don't want users to do that
each time. Any help is greatly appreciated.
Thanks,
Timothy Finn
|
| 302 |
I did that with no success. The Age field is being used as Criteria for
sorting. Does that make a difference? Thanks.
-Dave Trop-
"Tom Ogilvy" <twogilvy@msn.com wrote in message
news:uYKh8z4FCHA.2296@tkmsftngp05...
I suspect the number in the Age field is being stored as Text. Changing
the
format after the value is in the cell will not change how it is stored.
Format the cells as general before you do the paste special (although a
straight paste should work - as you state).
Regards,
Tom Ogilvy
"Dave Trop" <dmtrop@cox.net wrote in message
news:hyQP8.58441$Hn4.2007994@news1.east.cox.net...
In working with the data further, I find it is just the Age field
that
is affecting the macro. Even if I format it as General or Number, I
cannot
get the macro to work. If I type the same number into each cell that
was
copied there, the macro works fine. ????
"Dave Trop" <dmtrop@cox.net wrote in message
news:53QP8.58314$Hn4.1998285@news1.east.cox.net...
I have recorded a macro to sort, copy and paste text data (Name,
Sex,
Age) in a defined dynamic range onto another worksheet. If I actually
type
the data into the defined range, the macro works fine, but if I copy
and
paste the data from another workbook into the defined range, the macro
does
not recognize any of the data I have pasted. I have even typed a few
sets
of data in, then pasted (and even tried "paste special - values") a
few
sets
beneath them, then typed in a few more below those and when I run the
macro,
only the typed-in data is recognized.
Can anyone explain this to me? I thought pasted or pasted-special
data
was treated the same as data that was keyed in directly.
Thank you for any assistance.
-Dave Trop-
dmtrop@cox.net
|
| 307 |
i'm trying to create a spreadsheet with 4 columns: red, green, blue, and
color. the red, green, and blue cells are rgb values. i want the 4th cell
to have its background color set to the rgb values in its row.
help! this seems like it should be a simple thing to do in excel, but i
can't find a way to make it happen. i've explored conditional formatting,
script editing, and vb, but no luck. any suggestions on how to make this
work?
thanks!
|
| 308 |
Hi Will,
Next time you may not be as fortunate as to wipe out an
Excel builtin menu, it could have just as easily have been
one of your own making. So I would highly recommend
that you include backing your *.xlb file when you backup
your data files.
/dmcritchie/excel/backup.htm
also suggest printing out a print screen shot of the
top of your Excel window and one of your desktop as well
so you can comfortably be assured that they look the
same as before. More information on toolbars
/dmcritchie/excel/toolbar.htm
HTH,
, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: /dmcritchie/excel/excel.htm
Search Page: /dmcritchie/excel/search.htm
|
| 311 |
Excel is capable of displaying only 56 colors at a time (it's color
palette). The default color palette contains 46 different colors - 10
of them are duplicated.
If you use VBA to specify an RGB color that's not in the palette, Excel will
use the closest match. In other words, if you write a macro to change a
cell's color using RGB values, there is no guarantee that the actual color
will be displayed.
Here's a macro that will give you some info about the color palette in the
active workboook. It adds a new worksheet and then write six columns of
data.
Sub DisplayColorPalette()
Dim r As Long
Worksheets.Add
Range("A1") = "Index"
Range("B1") = "Color"
Range("C1") = "Value"
Range("D1") = "Red"
Range("E1") = "Green"
Range("F1") = "Blue"
Range("A1:F1").Font.Bold = True
For r = 2 To 57
Cells(r, 1) = r - 1
Cells(r, 2).Interior.Color = ActiveWorkbook.Colors(r - 1)
Cells(r, 3) = ActiveWorkbook.Colors(r - 1)
Cells(r, 4) = ActiveWorkbook.Colors(r - 1) \ 256 ^ 0 And 255
Cells(r, 5) = ActiveWorkbook.Colors(r - 1) \ 256 ^ 1 And 255
Cells(r, 6) = ActiveWorkbook.Colors(r - 1) \ 256 ^ 2 And 255
Next r
End Sub
John Walkenbach
For Excel tips, macros, & downloads...
-walk.com/ss
"Work Fast Party Horror" <news@busymonster.com wrote in message
news:tQ5Q8.360$bK.67166@news.uswest.net...
i'm trying to create a spreadsheet with 4 columns: red, green, blue, and
color. the red, green, and blue cells are rgb values. i want the 4th
cell
to have its background color set to the rgb values in its row.
help! this seems like it should be a simple thing to do in excel, but i
can't find a way to make it happen. i've explored conditional formatting,
script editing, and vb, but no luck. any suggestions on how to make this
work?
thanks!
|
| 314 |
You can put an apostrophe (') in front of the zero, but then Excel will
treat the entry as text.
"Timothy Finn" <timothy.finn@nytssc.com wrote in message
news:ea8001c217cb$784eb820$2ae2c90a@hosting.microsoft.com...
Is there any way to have Excel interpret a csv file with a
leading zero field as a character field so that it does
not drop the zero? In the csv file, I have the character
field enclosed in double quotes but it still treats it as
general. I realize I can add the zero back in using the
custom format option but I don't want users to do that
each time. Any help is greatly appreciated.
Thanks,
Timothy Finn
|
| 323 |
Thanks for the info. (50 meg might be worth it to find out if it can open
files).
Ron de Bruin wrote:
50 mb Dave
I have download it for my brother two weeks ago.(10 minuts that is better
than your puny modem)
O yes I forgot somthing <vbg
Regards Ron
"Dave Peterson" <ec35720@msn.com schreef in bericht
news:3D0FA860.66014496@msn.com...
Just a question and guesses:
Does excel blow up (with the same error) with any other workbook? If yes,
then
it's probably not this workbook.
If no, then maybe the workbook is corrupted (like Dave suggested).
I've had luck using xl2002 opening files that both xl97 and xl2k couldn't
open.
Sometimes formatting was lost, but the data/formulas/macros were there.
Other people have reported that Sun's OpenOffice/StarOffice can sometimes
open
corrupted excel files. (It used to be between 80-110 meg download. I
looked
and decided that it's too big for my puny modem!)
Not-for-free StarOffice.
/software/download/desktop_app.html
Free version
/dev_docs/source/1.0.0/index.html
IrelandA wrote:
Dear All
I have got a 3MB worksheet which I cannot open. When I try to open it, I
get
the following dialogue box:
===================================
Application Error
The instruction at "0x30099749f" referenced memory at "0x00000002". The
memory could not be "read".
Click on OK to terminate the application.
Click on Cancel to debug the application.
===================================
Even if I click on "Cancel", it doesn't open Excel, so I can't view the
spreadsheet at all.
Any help/advice gratefully received...
Regards
Alistair
--
Dave Peterson
ec35720@msn.com
--
Dave Peterson
ec35720@msn.com
|
| 327 |
One more slight change:
=VLOOKUP(A2,INDIRECT("'"&A1&"'!a1:b100"),2,0)
When I tested it, I put 'Jan-02 in A1. Excel liked to have this surrounded by
single quotes.
And the single quotes won't hurt if you really don't need them.
===
One more thing, do you really have the text Jan-02 in A1? If yes, then you can
ignore the rest.
But if you have a date in A1 (say 01/31/2002) and it's formatted to show just
the month-YY, then you might have to do something like:
=VLOOKUP(A2,INDIRECT("'"&text(A1,"mmm-yy")&"'!a1:b100"),2,0)
wrote:
Hi Brian, and Dave,
Correction to original formula and modified formula
The range must include Column A through Column B
in order to refer to column 2 in the table.
=vlookup(A2,INDIRECT(A1&"!a1:b100"),2,0)
Testing shows failure to include column B results in #REF! error.
"" <DavidH@OzGrid.com wrote ...
Hi Brian,
vlookup(a2,INDIRECT(A1&"!a1:a100"),2,0)
"Brian Ferris" <brian.ferris@go.com.mt wrote ...
| I would like to use a Vlookup, but I would like the name
| of the sheet to vlookup to be a variable:
|
| eg.
| Cell a1= Jan-02
| Cell a2= Brian
|
| Therefore
| Cell a5= =vlookup(a2,'Jan-02'!a1:a100,2,0)
|
| If cell a1= Feb-02
| Therefore
| Cell a5= =vlookup(a2,'Feb-02'!a1:a100,2,0)
|
| I would like to reference the sheet to look into with cell
| a1. I know this can be done with the Indirect Funcion
| somehow.
--
Dave Peterson
ec35720@msn.com
|
| 330 |
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
|
| 337 |
Hello Debra, this is going to sound stupid, but I have been known to ask
stupid questions or make stupid remarks, here goes it anyways. I started out
this letter with telling you that unfortunately the form is right on top of
the page, so I can't follow your instructions. Then I figured, this is easy
all I have to do is move the form down, and then do what you suggested. When
I tried to move the form it warned me that I will move some formats in
certain cells. That scared me enough to abandon the idea. I guess I have to
learn to either move, delete, cut and paste, and whatever the other options
are to move the form on the page we/of getting an error message about
formatting. Can you help me again please
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D10F74B.1000501@contextures.com...
To get rid of the border at the top of you form, select the cells in the
row above the form, then click the No Border button on the borders
dropdown.
I'm not sure how you're trying to set up the rows in your form. If you
want to start a new page at a specific row, you can select that row,
then choose InsertPage Break.
PeterM wrote:
I made a form that I use daily, I wish I could get rid of the to border.
When I go to borders, I look at the pictures of borders, and I don't see
the
no top border setup. Do the pictures of the border mean that if I click
on
them they will be there, one after another. IE click on the left border
first, then the right border, the bottom border, but I don't click on
the
top one. Maybe I'm looking at it the wrong way..................... I
like
to sneak in another question. My form has lots of rows. I took 6 of the
rows
and made them 40 in size. I thought that it would push the extra rows of
the
bottom of the first page, it made the rows real tight on the first page
though. Is there a way to just run them off the bottom instead of using
the
same space, and not crunching the rest of the rows? If it would flow
into a
second page, I guess that would be OK, I could just delete them. I
hope.Many
thanks...........Peter
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 342 |
Hi Peter,
Instead of moving your form, try the following:
1. Select the cells at the top of the form (the ones from which you want
to remove the top border
2. Choose FormatCells
3. On the Border tab, you'll see a diagram of your cells with borders:
________________________
| Text Text |
4. Click on the line at the top of the diagram, to remove the border.
5. Click OK
Debra
PeterM wrote:
Hello Debra, this is going to sound stupid, but I have been known to ask
stupid questions or make stupid remarks, here goes it anyways. I started out
this letter with telling you that unfortunately the form is right on top of
the page, so I can't follow your instructions. Then I figured, this is easy
all I have to do is move the form down, and then do what you suggested. When
I tried to move the form it warned me that I will move some formats in
certain cells. That scared me enough to abandon the idea. I guess I have to
learn to either move, delete, cut and paste, and whatever the other options
are to move the form on the page we/of getting an error message about
formatting. Can you help me again please
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D10F74B.1000501@contextures.com...
To get rid of the border at the top of you form, select the cells in the
row above the form, then click the No Border button on the borders
dropdown.
I'm not sure how you're trying to set up the rows in your form. If you
want to start a new page at a specific row, you can select that row,
then choose InsertPage Break.
PeterM wrote:
I made a form that I use daily, I wish I could get rid of the to border.
When I go to borders, I look at the pictures of borders, and I don't see
the
no top border setup. Do the pictures of the border mean that if I click
on
them they will be there, one after another. IE click on the left border
first, then the right border, the bottom border, but I don't click on
the
top one. Maybe I'm looking at it the wrong way..................... I
like
to sneak in another question. My form has lots of rows. I took 6 of the
rows
and made them 40 in size. I thought that it would push the extra rows of
the
bottom of the first page, it made the rows real tight on the first page
though. Is there a way to just run them off the bottom instead of using
the
same space, and not crunching the rest of the rows? If it would flow
into a
second page, I guess that would be OK, I could just delete them. I
hope.Many
thanks...........Peter
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 346 |
Dear Debra............ I tried it and it still has a border around it. Maybe
it is not a border, could it be looking the same, but it is something else?
When I click on the sequence of the suggested procedure, it shows no borders
in the place where the text box is. The box that shows the borders when you
click on the icon with the different border settings I mean. Is that darn
thing maybe a frame or something. I just don't know how else to describe it.
I hope you don't mind helping me some more. My senior heart appreciates you
a lot.............Peter
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D1109F5.8090302@contextures.com...
Hi Peter,
Instead of moving your form, try the following:
1. Select the cells at the top of the form (the ones from which you want
to remove the top border
2. Choose FormatCells
3. On the Border tab, you'll see a diagram of your cells with borders:
________________________
| Text Text |
4. Click on the line at the top of the diagram, to remove the border.
5. Click OK
Debra
PeterM wrote:
Hello Debra, this is going to sound stupid, but I have been known to ask
stupid questions or make stupid remarks, here goes it anyways. I started
out
this letter with telling you that unfortunately the form is right on top
of
the page, so I can't follow your instructions. Then I figured, this is
easy
all I have to do is move the form down, and then do what you suggested.
When
I tried to move the form it warned me that I will move some formats in
certain cells. That scared me enough to abandon the idea. I guess I have
to
learn to either move, delete, cut and paste, and whatever the other
options
are to move the form on the page we/of getting an error message about
formatting. Can you help me again please
"Debra Dalgleish" <dsd@contextures.com wrote in message
news:3D10F74B.1000501@contextures.com...
To get rid of the border at the top of you form, select the cells in the
row above the form, then click the No Border button on the borders
dropdown.
I'm not sure how you're trying to set up the rows in your form. If you
want to start a new page at a specific row, you can select that row,
then choose InsertPage Break.
PeterM wrote:
I made a form that I use daily, I wish I could get rid of the to
border.
When I go to borders, I look at the pictures of borders, and I don't
see
the
no top border setup. Do the pictures of the border mean that if I click
on
them they will be there, one after another. IE click on the left border
first, then the right border, the bottom border, but I don't click on
the
top one. Maybe I'm looking at it the wrong way..................... I
like
to sneak in another question. My form has lots of rows. I took 6 of the
rows
and made them 40 in size. I thought that it would push the extra rows
of
the
bottom of the first page, it made the rows real tight on the first page
though. Is there a way to just run them off the bottom instead of using
the
same space, and not crunching the rest of the rows? If it would flow
into a
second page, I guess that would be OK, I could just delete them. I
hope.Many
thanks...........Peter
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 358 |
Thanks for replying but not sure what you mean Aladin when I go to format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
Thanks again
Ted
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
|
| 361 |
I have MS Excel spreadsheets that have multiple worksheets
copied to a disk and am unable to open these files in
Microsoft Works Spreadsheet with all the worksheets. How
do I get my files in their original format?
|
| 362 |
It's been a long time since version 4, but check this:
Select your range (column?) and then Format|Cells|Number tab
Do you see an option called Text in the left hand box?
If yes, then click on it.
Any new entries you make will keep the leading 0's.
===
If you didn't see text (but I bet you did???), you can always prefix your typing
with a single quote.
'0001 will look like 0001 in the cell.
===
It's been a lonnnnnnnggggggg time for xl4--so I could be completely off base.
Ted Heath wrote:
Thanks for replying but not sure what you mean Aladin when I go to format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
Thanks again
Ted
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
--
Dave Peterson
ec35720@msn.com
|
| 366 |
I think that typing an apostrophe at the beginning of the entry is the
only way to enter a number as text in Excel 4.0
(At least it was the only option on the Mac version)
Dave Peterson wrote:
It's been a long time since version 4, but check this:
Select your range (column?) and then Format|Cells|Number tab
Do you see an option called Text in the left hand box?
If yes, then click on it.
Any new entries you make will keep the leading 0's.
===
If you didn't see text (but I bet you did???), you can always prefix your typing
with a single quote.
'0001 will look like 0001 in the cell.
===
It's been a lonnnnnnnggggggg time for xl4--so I could be completely off base.
Ted Heath wrote:
Thanks for replying but not sure what you mean Aladin when I go to format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
Thanks again
Ted
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
--
Debra Dalgleish
Excel FAQ, Tips & Book List
/tiptech.html
|
| 367 |
--
---
HTH,
, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: /dmcritchie/excel/excel.htm
Search Page: /dmcritchie/excel/search.htm
"Ted Heath" <tedheath@xtra.co.nz wrote in message news:Bj9Q8.584$K13.65138@news.xtra.co.nz...
Thanks for replying but not sure what you mean Aladin when I go to format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
Thanks again
Ted
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
|
| 369 |
Hi Ted,
format (menu) , number (tab), text
BTW you can see everything in format, number, custom
so if you have an accounting format that is close to what
you want, you could modify the cell format afterwards in
custom to fine tune it.
"Ted Heath" <tedheath@xtra.co.nz wrote ...
Thanks for replying but not sure what you mean Aladin when I go to format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
|
| 371 |
When I select range no problems I go to Format the drop menu is as I said :
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
no CELLS as a menu item.
Thanks for replying but I repeat I use version 4 (four)
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
"Dave Peterson" <ec35720@msn.com wrote in message
news:3D1124BF.874C52FD@msn.com...
It's been a long time since version 4, but check this:
Select your range (column?) and then Format|Cells|Number tab
Do you see an option called Text in the left hand box?
If yes, then click on it.
Any new entries you make will keep the leading 0's.
===
If you didn't see text (but I bet you did???), you can always prefix your
typing
with a single quote.
'0001 will look like 0001 in the cell.
===
It's been a lonnnnnnnggggggg time for xl4--so I could be completely off
base.
Ted Heath wrote:
Thanks for replying but not sure what you mean Aladin when I go to
format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
Thanks again
Ted
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push
enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
--
Dave Peterson
ec35720@msn.com
|
| 373 |
Then I think I'd use the apostrophe.
Ted Heath wrote:
When I select range no problems I go to Format the drop menu is as I said :
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
no CELLS as a menu item.
Thanks for replying but I repeat I use version 4 (four)
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
"Dave Peterson" <ec35720@msn.com wrote in message
news:3D1124BF.874C52FD@msn.com...
It's been a long time since version 4, but check this:
Select your range (column?) and then Format|Cells|Number tab
Do you see an option called Text in the left hand box?
If yes, then click on it.
Any new entries you make will keep the leading 0's.
===
If you didn't see text (but I bet you did???), you can always prefix your
typing
with a single quote.
'0001 will look like 0001 in the cell.
===
It's been a lonnnnnnnggggggg time for xl4--so I could be completely off
base.
Ted Heath wrote:
Thanks for replying but not sure what you mean Aladin when I go to
format I
have the following options in the drop down menu
number, alignment, font, border, pattern, cell protection, style, auto
format, row height, column height, justify.
Right click the cell same contents.
As I said I use version 4.
Thanks again
Ted
"Aladin Akyurek" <akyurek@xs4all.nl wrote in message
news:aeqv9g$otj$1@news1.xs4all.nl...
Format the cell as text *before* you enter a cheque number.
"Ted Heath" <tedheath@xtra.co.nz wrote in message
news:Hf6Q8.524$K13.60733@news.xtra.co.nz...
Hi,
I have Excel version 4 for a list of cheques banked each month.
It is the column which has the cheque number which is the problem.
One banks cheques start with 00 but when I type these in and push
enter
the
zeroes disappear.
Can anyone help please?
Cheers
Ted Heath
mailto:tedheath@xtra.co.nz
--
Dave Peterson
ec35720@msn.com
--
Dave Peterson
ec35720@msn.com
|
| 375 |
thanks, this is a great start! but, boy, the palette size is an annoying
limitation. some more questions:
1. can i set up a new color palette by assigning my own specific rgb values
to the 56 colors in the palette?
2. can i change color palettes when i change worksheets? that way i could
give the "illusion" of having more colors by only having 56 per page...?
thanks,
mark
"John Walkenbach" <john@j-walk.com wrote in message
news:uQxYnG9FCHA.1424@tkmsftngp04...
Excel is capable of displaying only 56 colors at a time (it's color
palette). The default color palette contains 46 different colors - 10
of them are duplicated.
If you use VBA to specify an RGB color that's not in the palette, Excel
will
use the closest match. In other words, if you write a macro to change a
cell's color using RGB values, there is no guarantee that the actual color
will be displayed.
Here's a macro that will give you some info about the color palette in the
active workboook. It adds a new worksheet and then write six columns of
data.
Sub DisplayColorPalette()
Dim r As Long
Worksheets.Add
Range("A1") = "Index"
Range("B1") = "Color"
Range("C1") = "Value"
Range("D1") = "Red"
Range("E1") = "Green"
Range("F1") = "Blue"
Range("A1:F1").Font.Bold = True
For r = 2 To 57
Cells(r, 1) = r - 1
Cells(r, 2).Interior.Color = ActiveWorkbook.Colors(r - 1)
Cells(r, 3) = ActiveWorkbook.Colors(r - 1)
Cells(r, 4) = ActiveWorkbook.Colors(r - 1) \ 256 ^ 0 And 255
Cells(r, 5) = ActiveWorkbook.Colors(r - 1) \ 256 ^ 1 And 255
Cells(r, 6) = ActiveWorkbook.Colors(r - 1) \ 256 ^ 2 And 255
Next r
End Sub
John Walkenbach
For Excel tips, macros, & downloads...
-walk.com/ss
"Work Fast Party Horror" <news@busymonster.com wrote in message
news:tQ5Q8.360$bK.67166@news.uswest.net...
i'm trying to create a spreadsheet with 4 columns: red, green, blue, and
color. the red, green, and blue cells are rgb values. i want the 4th
cell
to have its background color set to the rgb values in its row.
help! this seems like it should be a simple thing to do in excel, but i
can't find a way to make it happen. i've explored conditional
formatting,
script editing, and vb, but no luck. any suggestions on how to make
this
work?
thanks!
|
| 380 |
I have a problem that appears to be fairly widespread. I
haven't, however, found a solution to my exact problem on
this site...
Here's the trouble. I have a system of files that I need
to be able to transfer over to a different drive.
I've read that as long as everything is in the same
directory and the sub-directory structure and names of the
sub-directories are left intact that Excel will pretend
the references are relative (aka, I can move the files and
they will work). Alas, it doesn't appear to be working
for me.
Here's the magnitude of data that I'm worried about: 26
directories, 25 of which are designed to collect data from
different users (the whole reason this all isn't just one
file anymore), and 1 directory to compile this information
(and also serve as a source of a single piece of
information for every file in the other directories). In
each of the 25 directories, I will have 9 or 36
(undecided) files that I need to reference.
The collection folder contains two files - fetcher (which
gets the data for me) and sesdata (which the input files
need to reference). The collection folder is
named "master", the other inputs are all numbered. All
these directories are in the directory "qpa."
I try to move the directory containing both master and the
input folders (qpa), and all my links which, if relative,
would read "../master/sesdata" break. I would like to be
able to design this system on my pc, record it to a CD,
then copy it onto different computers. Due to the number
of links, the edit links option simply won't work. I am
willing to move the directory structure (to some extent),
try VBA (throw code at me, I don't do Basic), or whatever.
Or if I need to try to use Quattro Pro, tell me.
|
| 382 |
I have updated EveningStar's Summary of Microsoft Security Bulletins for
MS02-031 which Microsoft published yesterday. The summary is available at
/bwd/securitybulletins.asp
Bulletin MS02-031 applies to Excel and Word 2000 and 2002 (XP).
A high-contrast version of the summary is available at
/bwd/securitybulletins-bw.asp
This summary is intended to provide easy access to Microsoft-published
security hotfixes and related documents for their operating systems and
applications. Comments, suggestions for improvements, and criticisms are
always welcomed by this author.
--
David Dickinson [MVP}
EveningStar Information Services
eis @ nospam softhome . net
(Followup set to microsoft.public.security)
|
| 383 |
You could just leave the formats alone and sum, but you may find that
your sum's give you a somewhat bizarre result:
A1: 04:08:53 (4 days, 8 hours, 53 minutes)
A2: 03:16:07 (3 days, 16 hours, 7 minutes)
A3: =A1 + A2 === 07:25:00 (7 days, 25 hours)
If you want to convert the numbers to regular XL Date/Time format (days
as integers and times as fractional days, here's one way:
Since XL will interpret 4:8:53 as 4 hours, 8 minutes, 53 seconds, you
need to do a bit of manipulation:
A1: 04:08:53
B1: =A1*60 - 1.5*INT(A1*24) === 4.370138889
A2: 03:16:07
B2: =A2*60 - 1.5*INT(A2*24) === 3.671527778
B3: =SUM(B1:B2) === 8.041666667
or 8 days 1 hour.
In article <10aac01c218a2$776c9ad0$9be62ecf@tkmsftngxa03, M. E.
<mcook@magellanhealth.com wrote:
I am trying to be able to SUM and AVERAGE time for a
month. The time the employee is available may be so many
DAYS (24hours = 1 day) so many HOURS (60 minutes in an
hour) and so many MINUTES.
SO lets say someone worked 4 Days 8 Hours and 53 Minutes
In the cell we would format this for TIME and enter it as
4:8:53
I can't think of a way to write the formula that allows us
to truncate this number at the colons and multiply and or
divide by the appropriate factor (24 for the first colon
and 60 for the second colon.)
Microsoft Excel 97 SR-2
ANY HELP? Thanks!
|
| 384 |
I think that excel gets the format for dates from a Windows setting. It sounds
like one pc is different than the other and not recognizing the date.
I'm in the US and if I type 12/31/2001, I get a date (expected).
But if I type 31/12/2001, I get the text 31/12/2001--not really a date.
On the "bad" pc, if you format the cell as General (Format|Cells|Number Tab), do
you get a number? (I get 37621 for 12/31/2001 (using the 1900 date system).
If you don't get a number, then that cell really doesn't have a date in it (no
matter what it looks like). And since the value isn't numeric (it's a string),
the =text() has no affect on it.
If this looks like the case, then close excel and try:
Start|Settings|Control Panel|Regional Settings Applet|Date Tab.
Check (change to) the format.
Start Excel. I'm not sure if it'll react to the change or if you'll have to
change something for it to notice.
Hit F2 and then enter on one of the cells. Did it fix your problem?
If yes, maybe you can convert a whole column of dates at once. Select your
column and do a Data|Text to columns. Follow the wizard and make sure you
choose the correct (mdy?) format on step 3 of the wizard.
Good luck,
James Goodchild wrote:
Hi all
We have a Windows 2000 server running terminal services
and Citrix. Because of a requirement from a custom built
program, MS Office 2000 was installed to the local hard
drive of the Citrix server as well as to the Citrix
neighborhood. Everything loads fine and other than one
formatting issue, everything seems to work.
Here is the problem, in Excel 2000 in the local copy if
you type the following date 12/31/01 in cell A1 and then
enter the formula =TEXT(A1,"Mmm. Dd yyyy")in cell B2, the
result displays as 12/31/01. It should display as Dec. 01
2001. If we try the same formula from Excel 2000 under
the Citrix neighborhood install on the same server, it
works fine.
Unfortunately, the custom application is a reporting tool
that makes calls to Excel to generate graphs and charts
for the report and requires the local version. Anyone got
any ideas on how to address the format issue?
Thanks in advance.
--
Dave Peterson
ec35720@msn.com
|
| 410 |
Pct Profit = Profit / Revenue
Format as Percent.
Regards,
Fred.
"SkipperTW" <SkipperTW@yahoo.com wrote in message
news:aeu1pe$s6p$1@slb6.atl.mindspring.net...
Hello all, I hope someone can help me.
My boss is all over me about figuring out how to create a cell in Excel
that
will tell me the total percent earned on a particular job.
Simple example:
$1500.00 in expenses
$2500.00 in revenue
= $1000.00 total profit
(my question ???) What is the percent of profit on the job and how do I
write a formula in a cell for this so she can use it in the future?
My brain is fried and I can't figure out the formula. Any help would be
great.
Thanks,
SkipperTW
SkipperTW@yahoo.com
|
| 415 |
Select a cell or a range, then:
<Format <Cells <Alignment tab
In the "Horizontal" window, scroll down to "Fill"
And click <OK
Now, anything you type in the cell will fill it.
HTH
RD
"David Bauer" <davidbauer60@hotmail.com wrote in message
news:10f1601c218d4$a0f80f60$3aef2ecf@TKMSFTNGXA09...
How does one fill a cell with repeating characters to the
width of the cell? In Lotus 123 for instance, the
backslash followed by the character(s) does it: "\-"
would fill the cell with dashes, regardless of the width
of the cell.
|
| 421 |
David
This custom format will do the same in Excel:
@*-
--
Best regards
Leo Heuser
MVP Excel
"David Bauer" <davidbauer60@hotmail.com skrev i en meddelelse
news:10f1601c218d4$a0f80f60$3aef2ecf@TKMSFTNGXA09...
How does one fill a cell with repeating characters to the
width of the cell? In Lotus 123 for instance, the
backslash followed by the character(s) does it: "\-"
would fill the cell with dashes, regardless of the width
of the cell.
|
| 427 |
ADO assumes that the Excel data is in the format of a database table. That
is, the first row in the referenced range contains the field names that you
can use to reference each column in the range. If you want to get ADO to
return the information in the first row, use something like the following,
where rs is the object variable referring to your recordset:
MsgBox rs.Fields(0).Name
--
John Green - Excel MVP
Sydney
Australia
"Grisha Golberg" <junta@komkon.org wrote in message
news:uh5gn9rnaesm49@corp.supernews.com...
Hi all,
I have a very large (~25Mb) Excel spreadsheet that contains a bunch of
data
and formulas (duh :). The use of it is that a user needs to enter a
limited
number
of parameters, and get a report based on the data and formulas in the
sheet.
This
is a VB app, and talking to Excel via automation is a pain - it takes
quite
a while
to load the spreadsheet. I'd prefer not to touch the spreadsheet itself,
so
I thought
I'd be using ADO through OLE DB and xls driver to do the job. But I can't
find
the documentation on how to, say, get a value of a single cell? I realize
that technically
this approach works with sheets or ranges, but I can do something like
select * from [sheet1$d1:d2]
and get the value from cell d2. But I am puzzled as to how I can get at
d1,
for example?
|
| 430 |
Eric
One way:
Use this UDF (UserDefinedFunction) to get the date.
Copy and paste the code to a general module (<Alt<F11
Insert Module)
In a cell enter
=creadate()
Remember the empty parentheses.
Format the cell as Date.
--
Best regards
Leo Heuser
MVP Excel
Function CreaDate() As Date
CreaDate = ActiveWorkbook. _
BuiltinDocumentProperties("Creation date")
End Function
"Eric" <eric.goodrich@paccoast.com skrev i en meddelelse
news:11c9701c218a8$83d85380$35ef2ecf@TKMSFTNGXA11...
Is there a function in Excel that will return the date a
file is created into a cell?
|
| 434 |
Is there a way that a macro can revert to the saved
version of a spreadsheet? ie. If a user has made lots of
chnages to the spreadsheet, then clicks a "clear" button
it reverts to its original template format.
thanks
|
| 435 |
Pauline,
With your permission, I will email you an excel file that demonstrates the
FORECAST and TREND function. The file also includes the GROWTH function,
which should be used if your sales are increasing exponentially.
Results from the FORECAST and TREND functions should be the same if sales
are relatively flat (i.e. not exponential). A $10 million difference does
not sound right. Both functions involve linear relationships between
variables (linear problems can be represented by a straight line on a
graph).
General comments:
1. Using sales history for the past 5 years may not be representative of
your sales going forward. You may consider reducing your history sample to
say the past 12 months.
2. I recommend that you analyze your sales history for any unusual item,
transaction or event that may have effected past sales e.g. new product
launch, plant closure, strikes, government regulations (tariffs, changes in
the taxation regime etc.). You may wish to excise the financial effects of
these items from your sales history.
3. You may consider using Excel's CORREL function to correlate say
advertising expenditure with sales. Forecasting sales is one thing, but
will your company maintain its advertising expenditure?
Finally, using an Excel function for forecasting purposes is fine; however,
nothing beats a knowledgeable person who knows your market, customers and
products. I suggest that you bring such a person into your forecasting
exercise. In particular, you need top level information on proposed plant
closures, new product etc.
Regards
Mike
cbs@vianet.net.au
www.cobi.com.au
|
| 444 |
HI,
This could help, used in a other file.
Sub RevertFile()
Workbooks("Test2.xls").Activate
ActiveWorkbook.Close SaveChanges:=False
Workbooks.Open FileName:="C:\MYdocs\Test2.xls"
End Sub
HTH
Paul
"Et il en est qui s'étonnent encore qu'un message qui ne comporte ni
bonjour, ni merci, ne recoive pas de réponse" (Lao Tseu Atch Oum)
"Bruce" <bruce@nha.co.za a écrit dans le message de news:
11e8201c218ff$3286fe30$35ef2ecf@TKMSFTNGXA11...
Is there a way that a macro can revert to the saved
version of a spreadsheet? ie. If a user has made lots of
chnages to the spreadsheet, then clicks a "clear" button
it reverts to its original template format.
thanks
|
| 455 |
Hello,
I have a number of data files generated by a Vbasic program. The files are
of identical format though with a varying number of records. I need to open
all these data files into a single Excel worksheet and do some simple sums.
I'm sure I'm missing something simple, but I can't see how to merge several
excel files into a single worksheet, other than using copy / paste which
seems a bit clumsy.
With thanks
KK
|
| 463 |
How do you format a cell so when you have a minus figure
it shows up as a figure in brackets (i.e. accounting way)
i.e. (2,500
|
| 465 |
From the Menu Format | Cells | Number [tab] select Accounting in list
HTH
"Emma H-Byass" <emmahbyass@btopenworld.com wrote in message
news:10e1401c21925$355d0c50$9be62ecf@tkmsftngxa03...
How do you format a cell so when you have a minus figure
it shows up as a figure in brackets (i.e. accounting way)
i.e. (2,500
|
| 466 |
Hi Dave
I guess I wasn't as clear as I could have been. The issue
is on the smae computer - there are two instances of Excel
on it, one loaded directly on the computer and the other
loaded under Citrix on the same computer.
I did check the international settings, but wasn't sure
how this would effect one and not the other instance of
Excel.
Anyone else have any ideas?
-----Original Message-----
I think that excel gets the format for dates from a
Windows setting. It sounds
like one pc is different than the other and not
recognizing the date.
I'm in the US and if I type 12/31/2001, I get a date
(expected).
But if I type 31/12/2001, I get the text 31/12/2001--not
really a date.
On the "bad" pc, if you format the cell as General
(Format|Cells|Number Tab), do
you get a number? (I get 37621 for 12/31/2001 (using the
1900 date system).
If you don't get a number, then that cell really doesn't
have a date in it (no
matter what it looks like). And since the value isn't
numeric (it's a string),
the =text() has no affect on it.
If this looks like the case, then close excel and try:
Start|Settings|Control Panel|Regional Settings
Applet|Date Tab.
Check (change to) the format.
Start Excel. I'm not sure if it'll react to the change
or if you'll have to
change something for it to notice.
Hit F2 and then enter on one of the cells. Did it fix
your problem?
If yes, maybe you can convert a whole column of dates at
once. Select your
column and do a Data|Text to columns. Follow the wizard
and make sure you
choose the correct (mdy?) format on step 3 of the wizard.
Good luck,
James Goodchild wrote:
Hi all
We have a Windows 2000 server running terminal services
and Citrix. Because of a requirement from a custom
built
program, MS Office 2000 was installed to the local hard
drive of the Citrix server as well as to the Citrix
neighborhood. Everything loads fine and other than one
formatting issue, everything seems to work.
Here is the problem, in Excel 2000 in the local copy if
you type the following date 12/31/01 in cell A1 and then
enter the formula =TEXT(A1,"Mmm. Dd yyyy")in cell B2,
the
result displays as 12/31/01. It should display as Dec.
01
2001. If we try the same formula from Excel 2000 under
the Citrix neighborhood install on the same server, it
works fine.
Unfortunately, the custom application is a reporting
tool
that makes calls to Excel to generate graphs and charts
for the report and requires the local version. Anyone
got
any ideas on how to address the format issue?
Thanks in advance.
--
Dave Peterson
ec35720@msn.com
.
|
| 474 |
"Lepchen" wrote
I REALLY need to know if how to "shrink to fit" in a
cell.
Format / Cells / Alignment / Shrink to fit
Please email me the answer- I won't be checking the
newsgroup... PLEASE!
Then you haven't figured out what this Usenet thing's all about.
|
| 475 |
merci beaucoup!
-----Original Message-----
HI,
This could help, used in a other file.
Sub RevertFile()
Workbooks("Test2.xls").Activate
ActiveWorkbook.Close SaveChanges:=3DFalse
Workbooks.Open FileName:=3D"C:\MYdocs\Test2.xls"
End Sub
HTH
Paul
"Et il en est qui s'=E9tonnent encore qu'un message qui ne=20
comporte ni
bonjour, ni merci, ne recoive pas de r=E9ponse" (Lao=20
Tseu Atch Oum)
"Bruce" <bruce@nha.co.za a =E9crit dans le message de=20
news:
11e8201c218ff$3286fe30$35ef2ecf@TKMSFTNGXA11...
Is there a way that a macro can revert to the saved
version of a spreadsheet? ie. If a user has made lots=20
of
chnages to the spreadsheet, then clicks a "clear"=20
button
it reverts to its original template format.
thanks
.
|
| 480 |
Hello. Please help. I want to pick a range of cells for a
chart, but I want to do it automatically, by having the
range reference a cell which contains the adress of the
cell where the range should start. I have said cell adress
in left-hand text format. Say, B15 contains the adress
$A$11 as left hand text. I want the the range to be
referenced to B15, which will make the range start at
$A$11. Any ideas?
Anticipated thanks, John
|
| 489 |
I am trying to troubleshoot a problem where the format cells dialog
box will not appear when trying to format a cell with data in it or if
the cell has had previous formatting applied to it. The dialog box
appears normally when trying to format an empty cell or if the range
selected included an empty cell. I've tried pasting the data into a
clean workbook with no luck.
Has anyone ever seen this behavior before? I am using Excel 97.
Thanks in advance!
Chris Lunde
|
| 497 |
Let me rephrase the first sentence:
--Excel can only *open* Works spreadsheets that are saved as Works 2.0
files.
(My thanks to the quality control team.)
Debra Dalgleish wrote:
Excel can only only Works spreadsheets that are saved as Works 2.0 files.
Many computers come with a copy of MS Works. Maybe you can find someone
who can open your file in Works, and save it as version 2.0. Then you'll
be able to open it in Excel.
Copy the file onto your hard drive -- don't work from the floppy disk,
because it's very easy to damage the file that way.
Connie wrote:
I have an old but extensive Address Book made with a MicroSoft Works
program that came with my computer. It is now only available on a
floppy disk. I have tried to convert this floppy spread sheet file, to
what appears to be the same spread sheet in Excel 97 (Book 1, Sheet 1)
I've used MicroSoft Query with all the ODBC drivers installed but it
will not recognize the .WKS OR .TXT format in which I have it. This is
probably simple but so am I; I'm stumped! Please save me from a long
input session with an old hard copy.
|
| 498 |
On the spreadsheet you have (old one) select all the data.
copy.
on the new spreadsheet - paste.
did you try this?
good luck.
-----Original Message-----
I have an old but detailed Address Book from an old Works
program that came with the computer. I have tried to
transfer this spread sheet file to Excel's Book1, Sheet 1
which appears to be the same spread sheet as that from
Works. I've used MicroSoft Query with all the ODBC
drivers
and it will not recognize the .WKS or .TXT formats I can
put it in.
This is probably simple, like me, but I hope someone can
save me the task of inputing all that data from an old
hard copy.
.
|
| 500 |
Hello,
Thanks for your reply. I did look into Excel help, and found the same advice
you gave me, but it was not helpful. I think you misunderstand my question
I don't have copies of a shared workbook, I have several data files of
identical format but with different data and with different numbers of
records.
I am not trying to merge changes to a shared workbook, I am trying to
merge/insert/join/combine these several files into a single worksheet so
that I can do some sums on all the records therein.
My apologies for the confusion
KK
" |