I am inputting 4e6 in a cell and selecting the format for General so
this "4E6" will display as i want, but instead it keeps reverting to
Scientific. How do I get this to maintain the General Format? I looked
at the Auto Format function but this didn't work for what I am needing.

I am running excel 2003 XP.  I am unable to validate criteria from on
workbook or worksheet to another.  I get an error message "unable t
validate criteria from one workbook to another"  At home I am able t
do this no problem. (office 97)  I am able to validate criteria withi

Does anyone know if Excel 2000 can be set up to paste plain text b
default.
I need to copy and paste a lot of data from html pages and exce
insists on pasting the html formatted data unless I chose past

I use the Data text to columns option all the time when I need t
seperate things into several columns.
How do I do the opposite. I want to take the text that is in severa
columns and put it into one column?

I'm sure this is a simple fix but I've spent
way to long trying to figure out how to stop
the stupid task pane from opening every time
I open Excel 2003. I've tried going to view

Could someone please tell me how to construct a
conditional formula based on date or on your computer's
system date?  Is this even considered a conditional
formula?

Our bookkeeper has done something to a worksheet that I
can not figure out, either how she did it or how to fix
it. The solution is probably staring me in the face but I
can not see it.

Say at a certain range I wish to highlight a cell or entire row. For a
example anything 50.00% and higher is highlighted red
--
Message posted from http://www.ExcelForum.com

Does any one have an xl template to track vaction time available and taken,
for 2004?

Let's say I work in Excel 2002 and I protect my workbook using the "Protect
and Share Workbook..." functionnality (or any other). Will my workbook be
protected if I open it in Excel 97?
TIA! :O)

it seems to be having a problem.
I start excel as normal from the start menu and then Microsoft Excel,  then
I click a box to start typing, if after clicking a box, and I move the mouse
in any direction it starts to select boxes.  like the mouse button is

I'll admit, I'm not a good Excel user, or google searcher, so I'm hopin
someone can help me.
If you have a google toolbar, you customize it, then use it, but clos
excel and reopen it and it goes back to how it was before....?  Is thi

I'm trying to run a VLookup with account IDs, the problem is I may have two
that are the same but in different cases :
00100000002s74J
00100000002S74j

i need to make excell keep 16 digit number intact.  now scientific o
rouded expressions are allowed.  Is this possible
--
Message posted from http://www.ExcelForum.com

Have some problem in consolidating similar data:
Example in this stationary spreadsheet,
Project group           Item Desc                    Qty
AAA                          Pencil                           10