converting "text" numbers to numbers
I have been using the technique of multiplying cells that have number
entries that behave like text entries by the value of 1 to convert them to
numbers. However, some mixed cell entries, convert strangely. For example
the entry "6 A" (without the quotes) becomes 0.25 when multiplied by 1.
Any explanation? Any ideas on how to solve other than checking cell by cell
to confirm all characters are numbers?
Confused! Frustated! <grin>.
Just figured out the "why". An entry like 6 A is converted to 6AM. Its
numerical value is 0.25. Still hoping for a ...When I open up excel a worksheet that has been inputed opens up w.
How do I start excel with a blank worksheet
There is either some excel file in the starup folder or files are opened
through Tools, Options, General Tab, "At startup open every file from
(please note this option may vary since I am using a french version)
"EL GUAPO" <ELGUAPO@discussions.microsoft.com> a �crit dans le message de
> How do I start excel with a blank worksheet
No, that's not it. That does just what it says, it opens every file in that
folder. H...Why does my excel spreadsheet show ### in place of a sum?
For some reason, some autoSUM cells in my spreadsheet are showing up as "#"
symbols even though they are correctly calculated in the function window...
Try making the column wider.
"S. Teichman" wrote:
> For some reason, some autoSUM cells in my spreadsheet are showing up as "#"
> symbols even though they are correctly calculated in the function window...
> Any ideas?
Typically the # characters indicate that the column is not wide
enough to display the result. Try making the column wider.
Microsoft MVP - E...How do I merge similar data across different excel worksheets?
If you have a unique key value that's on each sheet, you could use =vlookup() or
You could look at Debra Dalgleish's site:
...Outlook HTML & Text Messages
I have my Outlook 2002 set-up to send and reply/forward
messages using the HTML format. However, recipients
(including me as a .cc) receive the e-mail in the TEXT
format. The messages always appear correct when viewing
them in the SENT folder. I have experimented with
various selections to NO avail. Please advise what I am
Are you using an ISP or Exchange server for mail? If Exchange, check with
the admin to see if the server is set to strip formatting.
BTW, not all people want or appreciate HTML mail so you may want to rethink
that strategy. I do not like it and ...Exchange 2010 Disclaimer HTML/Plain Text
I've been playing with the Exchange 2010 disclaimer feature
I added some simple html <br> tags, <font size=small> and some active
directory %%Company%% variables.
I was curious what would happen if I sent a 'plain text' formatted email
What the recipient is seeing in this case is that it strips the html tags I
added, but it ADDS following to the email......
Has anyone seen this? I was looking for a rule to possibly create separate
HTML or Plain Text disclaimer...Macros in Excel
I have a question about macros...why does Excel open a
workbook for a macro? I created 2 of them (I'm a beginner
with Excel macros) and I noticed that when I run a macro
another workbook opens with the macro name.
Is there any way to prevent this annoying feature? I used
to macros in WordPerfect eons ago and this never was an
Don't you want to be able to use the macro in *any* workbook.
To me that is what macros are all about, extending Excel, to
provide facility that is not there, or should have been there.
Correctly installed into personal.xls you wo...Converting month number to text equivalent
This is a multi-part message in MIME format.
In cell A1 I have the date 01/06/2004 (Jan 6th, 2004) displayed. I want =
to list the Month and Year of the previous month in cell B1. In this =
example I need "DEC-2003" to display. Can anyone help?
<!DOCTYPE HTML PUBLIC "-//W3C//...Linked Text Boxes with Exact Objects copy/paste
I am trying to change the layout of a 8.5" x 11" four page document to a two
page 17" x 11" document. The four pager consist of four linked text boxes as
pages with lots of graphics in each. When I rope the textbox plus the
graphics, copy and then paste I only get the an empty textbox plus the
graphics, the text is gone. I think this has something to do with the graphic
objects Layout set to exact, but I would have to spend a few hours changing
all of the objects to inline. Time is what I lack.
Is there a way to do this. That is, copy and paste linked tex...EXCEL #37
�Podr�a algui�n explicarme para qu� sirve la Herramienta Solver y c�mo
solver te sirve para buscar resultados cambiando otros datos. Por ejemplo,
tenes el total de ventas y costo, lo que te da un margen del 10%, con solver
le podes pedir saber que cantidad de ventas necesitas para alcanzar un margen
Si esto te ayudo por favor hace click en Yes, gracias
"7C agotz" wrote:
> ¿Podría alguién explicarme para qué sirve la Herramienta Solver y cómo
> funciona? Gracias!
...Excel Relative Reference
On Excel XP, how do you switch back to the normal
column/row headings where it would equal A1 rather than
the relative which is 1:1? Please let me know how I can
You probably refer to the Reference style:
Tools>Options>General, uncheck R1C1 Reference Style
Microsoft MVP - Excel
"Trisha" <email@example.com> wrote in message
> On Excel XP, how do you switch back to the normal
> column/row headings where it would equal A1 rather ...Excel:I set the font color to be "Red". Next time file is open, f.
Say I sent the font color to Red in the cell. The next time I open the file,
the font color in the cell changes? Why
Maybe you didn't save the file?
>Say I sent the font color to Red in the cell. The next
time I open the file,
>the font color in the cell changes? Why
...How do I delete cells in Excel without changing the data in others
I want to get rid of some of the rows in my spreadsheet but the data in the
ones I am leaving behind are linked by formulas? As soon as I delete them all
the data goes from the the others.
I may not understand your situation. An example of what I think you're
saying is: Cell A2: A1+1. You want to delete cell A1, but leave A2 with the
value it currently has.
If this is the case, you need to copy A2 and the, using paste special, paste
the value back into A2. This way A2 no longer has any formula at all and
will remain unchanged when you delete A1.
"G...excel chart to tiff or eps format
I have created several detailed charts in excel for a paper that I am
sending to a journal. The journal requires that my files have eps or
tiff extensions. How do I convert the excel chart into tiff or eps? I
have tried to 'print' to tiff with microsoft office document image
writer , but the quality of the chart is too low. I also tried to copy
and paste the graph into paint shop pro and to save it as .eps , but
agai the quality is too low. Any other suggestions would be much
In VBA you can use
ActiveChart.Export "C:\test\MyChart.tif"...Sharing Excel files
I'm sharing a file on our network (approx 1mb in size). occasionally, the
print areas are completely cleared. aside from user intervention, is there
anything that can cause this?
Not sure about Excel 2000, but in Exel 2002 there is a sharing functio
you have to turn on. From you discription, you do not have it turne
Tools > Share Workbook...
Most of the options that come up are self-explainitory, but you ma
want to review the help files are keeping tracking of a change histor
if you want to do that
~~ Message posted from http...Word Wrap hiding text
Has anyone experienced word wrap in excel hiding all text. It has come
on all of a sudden and is causing problems with every excel file I
open. I have seen other posts here but no resolution.
I have the same issue....
> Has anyone experienced word wrap in excel hiding all text. It has come
> on all of a sudden and is causing problems with every excel file I
> open. I have seen other posts here but no resolution.
...Excel cell format #2
how can i display preceding zeros in excel without formatting as text?
In article <5CBDC357-B0B2-49C2-906C-73E94C6172B9@microsoft.com>,
"rockfam8" <firstname.lastname@example.org> wrote:
> how can i display preceding zeros in excel without formatting as text?
Precede your entry with an apostrophe. For example...
Hope this helps!
Or give it a custom format like
(as many 0's as you need)
> how can i display preceding zeros in excel without formatting as text?
...why are some gridlines in an excel worksheet dark and some light?
I have lots of data entered==6-700 different names, address etc. Some of the
gridlines printed dark, some were light and some were dotted..How do I make
Select your entire grid and set the borders the way you want them.
MVP Microsoft [Publisher]
"Joyal" <Joyal@discussions.microsoft.com> wrote in message
>I have lots of data entered==6-700 different names, address etc. Some of
> gridlines printed dark, some were light and some were dotted..How do I
> ...Excel 2000 #2
How come the Move or Copy Sheet under Edit is grayed out for this particular
data file? I can't access it.
Is the workbook protected?
(You may need a password)
> How come the Move or Copy Sheet under Edit is grayed out for this particular
> data file? I can't access it.
...deleting phrases in Excel and/or Word
My question is for beginners but I am working with spreadsheets and documents
which contains a lot of the same words I want to delete. Can anyone please
tell me how I can do this? THANK YOU BEFOREHAND FOR YOUR HELP!
Here's one quick play using SUBSTITUTE for progressive deletion ..
Assume text data is running in A1 down
Enter the exact words/phrases (case sensitive) you want deleted in say K1
down. Eg assuming you have 3 words to delete:
in K1: the, in K2: Oops, in K3: milk
Then place in B1:
Copy B1 across by 3* cols to ...Office / Excel 2003
Hope someone here can help me out.
Upgraded from Excel 97 (Word too) to Office Pro 2003 installing everything
on an XP Pro desktop connected to a network running Microsoft SBS2000.
Now, when I simply open Excel, I get: "The file cannot be opened because
your virus scanner has detected a problem with the file.". But I'm not
trying to open any file, just Excel. HELP!
I get the same thing in trying to open an old file, saved in Excel 97.
If I add anything to one cell (or two, just something at all) and then save
the file it saves it but when I go to open it with the O...Formula for computing work time in Excel
For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.
What is the formula?
If I use formula B1 - A1 - 0:30 I get invalid value.
email: alex DOT vinokur AT gmail DOT com
"Alex Vinokur" <email@example.com> wrote in message
> For instance, A1 = 8:20, B1 = 16:30.
> I need to compute in C1 the fo...Save as Web Page for Excel 2000
I am new to Excel 2000 and attempted to save an Excel
Document as Web Page that can be changed interactively.
However, when I change the content in that spreadsheet via
IE, it seems that the underlying spreadsheet is not
updated. Is there anything wrong ?
You should "publish" not save as. In the SaveAs Web
Page ... dialog box, click "publish".
You have to edit via the excel.htm as it really isn't an
IE web page. If you edit with IE you are only changing the
html not excel data. . >-----Original Message-----
>I am new to Excel 2000 and attempted...Need help with excel autofill VBA style
Hi everyone, I need help with autofill. The situation is that I have an
excel spreadsheet that contain 2 worksheets: sheet1 and sheet2. The sheet1
basically contains just raw data; while sheet2 contains a number formula
that are used for calculation.
A B A B
1 2 1 1 Sum AVG
2 3 9 2 =SUM(Sheet1!A1:Sheet1!B1) =SUM(Sheet1!A1:Sheet1!B1)
3 7 1 3
4 8 2 4
The question is that I want to write a VBA script that will autofill
the formula in colum...Excel 2003
I often work with spreadsheets of 4-10 columns and as many as 400
Lately (maybe since I loaded 2003, I can't remember) whenever I try t
copy or cut large numbers of cells I get the message:
"The picture is too large and will be truncated."
I used to cut and copy large numbers of cells in Excel for XP all th
time...can anyone help?
Message posted from http://www.ExcelForum.com
I'm the same guy who posted the question...
...but here's the thing I've since figured out:
Even though I get that message, Excel still copies all my data to...