Lisa, the first problem sounds like the cells are formatted as text, change
the cells to something else BEFORE putting the formulas in
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Lisa AGA" wrote in message
...
I am working with a customer who is encountering issues that I cannot fix.
She is using 2k and the workbook itself is huge: 16.5 MB's. Does anyone
have
any idea what the issues might be abd how to fix it? The explanation of
what
is occurring is below:

Wendy says:

It's the same old problem...

As you know, the equal sign - when it's the first character entered to a
cell - should tell Excel that a formula or function will be following
it...and to perform the function. However, this often doesn't happen in
my
Excel workbooks. After entering an equal sign, I will often see the
formula
itself typed out as TEXT. This doesn't apply to all worksheets, nor to
all
cells on one worksheet.

As an FYI, I don't have Excel setup to display formulas.

The attached file is an example of Excel entering formulas as text instead
of taking them as formulas. You might want to enter some formulas to the
worksheet so you can see what happens.

There is a work-around which corrects the problem. This is to format the
cells as "general" and then strike the F2 key. I don't know why this
works,
but it does. However, you can only do this to 1 cell at a time. This is
VERY tedious. You can do this to one cell and then copy the cell. That
works.

I go through this almost every day. I'd appreciate any help you can give
me.

Thanks,
Wendy

p.s. Maybe MicroSoft has a solution. It seems like it should be their
issue.


As long as you're dealing with ugly Excel problems, I'll add one
more....just in case you run across the solution to it while you're
researching the other problem. The 2nd problem is also very
time-consuming
and, for this reason, very frustrating.
Especially when you're under tight time constraints.

I'm attaching a file which shows the gyrations I go through for some
lookups. Two sheets illustrate the problem. They're the first 2 sheets
in
the file ("WPR_Wksht#1" and "Volume Drivers"). The columns in bright
green
are the columns used in the lookups. The headings explain the data in the
various columns. If it's easier, we could walk through the problem
together.
Just give me a call at your convenience. (Note: this problem almost
always
occurs with data that's come from
the mainframe. Although, since XP has been installed it also
occassionally
occurs with data that's been keyed.)

These two problems take a lot of my time and it seems like it's always
when
time is short. I would greatly appreciate it if I didn't have to deal
with
them any longer!!!

Thank you for your help,
Wendy


11/3/2006 2:09:22 PM LLAROSA1
downloads from mainframe happens often,. also happens with new documents,
but more with these downloaded batch files. The batch files are exported
in
.cvs we think.