I am trying to use the following formula to display a text version of a number:
=TEXT(cell,"#.#")
To show numbers in a 0.0 format.  
However, when I get to one figure 20.0 - it displays it as 20. rather than

Guys, I need to do something clever with months - although right now I'm not
quite sure what the best approach is.
I'm developing a yearly Company Ledger workbook with 13 sheets, one sheet
per month, plus one 'Setup' sheet as the first sheet.

if C column has TRUE, I want the line(A through C column) to be formatted.
I want to use conditional formatting.
formula:="$c=TRUE"
target=$A$1:$C$274

I am trying to search a column of date that contains dates that were
calculated. (starting date + # of days out = end date). I am using the
following search macro code. This code works when the date is entered into
the column. It does not work when the date is calculated with the ...

I want to be able number columns across the top of my excel sheet.  EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?

Just a quick note that, IMHO, Excel 2007 is not ready for normal usage, particularly on XP (where it behaves oddly, e.g., fails to
open up XLS files when you double-click them; it works better in Vista).
But the biggest problem is that Excel 2007 interoperates very poorly with ...

I have 2007 it's not a function under Data.  Where and how can I get this?

On an existing spreadsheet with a header, how do you premanently remove the
header?

In an attempt to save file size, I would like to use paste special to
past Excel graphs as pictures within Excel.  I know you can paste
special as pictures within PPT, but is it possible to do it within
Excel????

I am working in Excel 2007 on a spreadsheet created in 2003 - when I try to
insert a row (on any sheet) I get the message "cannot shift objects off
sheet" and the OK button.  Not sure what this means or how to correct it but
I cannot insert any rows.

Forgive the newbie question. I am looking to perform an action on a
range of rows (ex. - COPY the contents of cell A1 to Cells K1 through
K21,777 or DELETE Rows 2 through 10,801).
Is there an easier way to do this than dragging the cursor down the

I was just wondering if any of the new-comers to Excel ever thought of
reading a book about Excel. Or is it easier to ask a question and get an
answer rather than to explore the new subject by reading a book, working
one's way through the exercises and perhaps having a small ...

I can not locate XML on my Data menu for Excel.  I checked to see if it was
an add-on but it's not.

=GETPIVOTDATA("PrehuntTotal",'pvt prehunt ASMtotal'!$A$3,"COUNTY",$AF
$2)
Those familiar with the GetPivotData function know that "pvt prehunt
ASMtotal" is the name of the pivot table and "PrehuntTotal" is the

I have a list of names each of which has the word "count" appended to the
end, e.g. John Smith Count.
The names are all of different lenghts.
Is there a way to remove "count" from the right hand side of the text?