I want to display a four digit number which may or may not begin with zero,
i.e. (0215) (0050)

Dear Sir,
The number in text format is normally denoted by a ' before it.
Eg. '62417, '47125 etc.
Let say I have a clumn of numbers, may I know how to convert it into text

I need to print an excel worksheet to 11 x 17 paper, which sometimes is
called tabloid or ledger paper. None of those sizes are an option, though (at
least not that I can tell). I can't imagine that given all the print size
options that 11 x 17 wouldn't be one of them. Can ...

I have a rather large spreadsheet that contains several non-adjacent cells in
a given column that contain a large amount of data, stretching the column way
too wide.
Is there a way to force the data to break into two or more lines within a

I want to limit entry into certain cells to shift/ctrl/; (timestamp) so that
it can be used to keep track of actual time. How do I do this?

I'm trying to complete an average for time.
The problem is I'm doing this over a 12month period so the months where
there is no data I'm getting the #DIV\0!
in each month i have a time colum at the bottom of each i have a monthly

How can I do Data Entry Validation for all the cells in a column.
I want to make sure all entries are:
 1.   Exactly two characters long.
 2.   Are all upper case.

Excel wants to change it for me, every time.  The cell is formatted as
Text.
How do I suppress this feature?  I can't find it in Options.
Thanks!

I would like a cell to change color if the cell contains one of 2 specific
words (maybe 3 words?).  The cell may contain that word alone or that word
and addtional words.  I only need the formula, I know how to change the cell
format.

First, thank everyone for your help to me previously.
I've run into a need repeatedly that I'm sure a VB code will solve.
I have a spreadsheet that contains columns A to J and rows 1 to 100. The
word "Paid" appears sometimes, not always, in column H of my data.  I need a

I am trying to get ask if H2 is greater than or equal to 50 and I2 is letter
C please make true

I have macros in an Excel 07 personal startup file.  When I close an excel
doc, excel remains open due to the personal.xlsb/xls file.  So I have to
click close twice.  This did not happen in 2003.  What is the
fix/workaround/setting for this?

I'm trying to find a way to copy the Qty from Column "C" and paste into
Column "D"
next to it's respective hardware cell(s). I hope the follwoing shows what
I'm trying to explain...

I created a network days formula that excludes holidays,
=NETWORKDAYS(E12,AU12,$A$1:$A$9).  Saved on a spreadsheet in a shared file.
Works on my computer when I am logged in.
Doesn't work (get the 'name' error):

Currently when I am exporting from a program into Excel it takes 0 08:35 to
515 inside excel. I am wanting to try and get a formula to be able to convert
the 515 back to 0 08:35.
I'm open to any ideas as far as fixing this issue. I have scowered the web