How do i format a cell to display the values in cents?

I have modified a spreadsheet, and now am using "Save As" to save it.
When I save it I get the Microsoft Excel Alert (yellow triangle with
exclamation mark) with the message:
"Your formula contains an invalid reference to an external

I'm sending data from Access 97 to an Excel 97 spreadsheet.  I hav
broken up the code in a logical order according to the kind o
formatting needed for each group of sheets.  
The problem is when I try to send data to a group of nonadjacen

Any ideas from anyone would be greatly appreciated. Thanks
I tried posting in the same thread but since this was
several days ago it wasn't answered.
Thanks Peo.

I do not seem to be able to change alpha data already entered into
spreadsheet from 'lower' case to 'UPPER' case via using the formula.
The help files are not helping!  Can anyone show a step by step proces
to chage 'david' in cell 'c3' to 'DAVID' in the same cell?  Or t

I had Excel within Microsoft Office 2000 Pro, now I'm using Office XP pro,
in Excel, I used to search for files by just putting in the first three
numbers or letters of the file name and then Excel will give me all the
matching files, but in Excel XP, nothing happens and search does ...

What macro would I need to : Print(A18:K155) ?
--
Thanks in advance for your help....Bob Vance
.

I have about 1000 names entered in my excel worksheet.. I am trying to sort it, but when I go to Data > Sort, sort is greyed and unavailable. How can I get this function to be available again?

Something recently changed in excel when I am creating
formulas and I can't figure out what it is?
When I type in a bunch of numbers down a column and I
click on autosum - the box that open in the cell

Is it possible to have Excel automatically put the date of a specific day of the week in a cell?  I submit a timesheet every Tuesday.  I would like the date of the next Tuesday automatically displayed in the Date submitted cell on the worksheet

Does anyone know whwther Excel can do One -way repeated measures?

How it is possible to obtain a reverse function for
cosinus, sinus or tangente like
COS(30) = 0,866025...
and COS-1(0,866025...) = 30

I have a list box that I need to make and it's pretty
easy.  11 Plant Names in the box is all I need... Why is
this so difficult for me to figure out how to do it?
Does anyone know what I need and how to do it????

I'm interested, for instance, allways to get the last 30 values of a
series of values from one column. Everyday, there are more and more
records, no constant number. Is it possible ?
Thanks

I am trying to create a macro that will move the contents
of a cell to two cells below.  I have created a macro
that will move the cell, however, how can I edit the
macro in vb that will tell it automatically move it two