I have a spreadsheet that has data imported from SQL Server or even MS
Access that has dollar amount fields. The field is coming over as a text
field and even if I format the cells as currency it won't apply the
formatting until I actually double click in the cell and press enter.

I have two access files one is My Tables and Second is My Forms.
I have all the tables in My Table database and All forms,quries and reports
in My Forms. Both of this databases and kept in one folder called My Folder.
I keep moving this My folder form my Laptop to my home computer ...

I'm at a loss as to how to effectively use Excel's
Database Query function.  I can pull in all the records
for the fields I want but have been unable to figure how
to pull in just the one record I want.

Every time we open a file from our network share and then try to save it we
get the messsage "The file filename.xls may have been changed by another user
since you last saved it. In that case, what do you". We are then asked to
"Save a copy" or "Overwrite changes". This message ...

is there anyway i can lock a cell so it cant be changed, someone please help
me..thanks

I have an excel spreadsheet that I need to convert to a .csv to import.  One
of the columns is the zip code, including codes that start with 0.  However,
whenever I convert it to .csv, it strips out the first 0 of the zip code,
thus leaving a 4 digit code.  Is there a way to fix ...

How do i trigger a macro when a spreasheet opens?
Cheers!
Neil

I have a mailing list, and about 1/3 of the records do not have email
addresses.
QUESTION: how do I sort the list so that only the records with empty email
address fields appear?

I have a cell that is colored according to a conditional formatting
statement. I want to copy the color to another cell using a macro but I
can't find the property. In particular, Range.Interior.ColorIndex is NOT
set. I can examine the colors using Range.FormatConditions(index)

Need to create a macro so that when  cell A2 contains value of 1(for
example) in it, the cursor moves to a new cell address (like D200)
Need also a macro to print a sellection (range of cells) in a spreadSheet.
Thanks in advance

Can anyone point me in the direction of a simple checkbook register that can
also show actual as well as current bank balances? I found a nice one on the
ms templete in personal finance and love it but I do not know how to insert
a colum to calculate current bank balance before ...

I am very computer/internet retarded   PLEASE help me   I know that I have
the programs to do what I want but feel CRAZY b/c I cant figure out the
simple stuff.  All I want to do is Type up a poem and print it out. I have
Microsoft Outlook, Microsoft Word, Microsft Excell.... ...

Is it possible to open a csv-file with a number of columns that are
separated be a certain separator in Excel, so that Excel puts the text in
the right columns automatically by looking at the separator. I want Excel to
do this without using the wizard 'Text to Columns'. This ...

The spreadsheet is for simple cash book accounting. Columns are:
Date / Received / Paid / Transaction Details / Balance
There must be 1 entry in either Received or Paid, but not both.
When there's an entry in Received there's no entry in Transaction

I have asked this before but I am looking to have a spreadsheet that will
calculate the hours worked minus their meal breaks.  I would like to do 2
things:
1st one is :