For instance, with VBA I am trying to place "February 2007" in a cell
but it keeps showing up as Feb-07. I want it to show up as literal
text.

I've got some data in the format:
$9,212.00
I want it to show as
9212.00

I am trying to compare some old spreadsheets and upgrade to the new and have
a case in try to determine if a value was added to a formula inside a cell.
So I would like to do a search/find on the contents of the FORMULA in the
cell.

Here's one again:
I've got various amount in different currencies (i.e. yen, euro, singapore
$) in column L. What I want now is to convert these currencies into US$ in
column M as I enter the value in column L. How do I do that?

I'm facing up the following issue: in a sheet there's a matrix of
boolean values (TRUE, FALSE) that I have to read/write via vba.
Sometimes (not deterministically), a statement like:
if Cells(2,4).value then

If I have a spreadsheet where the data in each row corresponds to a
unique company, what is the fastest and easiest way to copy each row
reference to its own spreadsheet?
If the data in Sheet1 is updated, I want the data in the other sheets

To log incoming mail using Excel, I would like to add an extra line or lines
to just one cell as required, I know there is a keyboard shortcut can anyone
help please.

I copy a list of hyperlinks with friendly names into a spreadsheet.
However, I want to extract the underlying hyperlinks into their own cells.
Is there a function or a property I can use in a macro to address the
hyperlink behind the friendly name?

I have the time in for one column and the time out in the adjacent
column.  I then use this formula to subtract one time from the other:
=IF(C43=0,0,C43-B43+(C43<B43))
It  works fine, but I just noticed that if the time out is exactly

Can anyone please tell me why on earth sometimes these stupid green corners
appear.
when I do a sum with any of them  I get a zero.
If I ignore the green corner things , it won't count, but if I convert to

Through Data > Validation, I've created a drop down list  for a column to
enable the user, when going into the cell , to choose what is listed. They
are 3 letter codes. ie.
RCC   |  Royal Caribean Cruise line

I get the following message when I open a workbook I'm using.  I have
no idea what it's refering to.  How can I figure that out so I can
stop this message from popping up every time?
"The workbook you opened contains automatic links to information in

How do I display two spread sheets side by side?
So that I can read from one and edit the other spread sheet, at the same
time?
Thank you.

Let me preface this question by saying no know virtually nothing about Excel
- I am an Access programmer - so please dumb down your answer for a newbie.
I have an Excel file supplied by my user. It started life (I think) as a
.pdf file that they somehow converted to Excel ...

Hi,
Can someone assist pls. Here's the scenario:
IF C2=C, the value in N2 is to be transpose to O2 then delete N2 value.
thanks,