I need help converting a number to a time value.
In one cell I have the number 10.  I need to convert it to 00:10
minutes.  Is this at all posible?
Thanks

Hi all... I'm sure tihs is a simple VLOOKUP problem, but I can't seem to
figure out the issue.
I have a lookup table of Nation abbreviations and the corresponding full
name:

Hi, recently learned the joy of pasting an entire 2D array into an excel
range in one step instead of looping through array elements and pasting into
individual cells. I use a collection to populate the array and the downside
is everything comes out as strings, regardless of the ...

I am trying to remove one (or more) black spaces before words in a
spreadsheet. I can use the =TRIM() function okay to remove the first blank,
but want to use the resulting column in a mail merge exercise. As (I think)
you need to insert another column to cater for this formula, ...

very basic question, but it is making me crazy.
I've used the "name box" to label some cells.
What is strange, I'm not more able to rename them or remove the
"label"..

I have an Excel addin that if Excel is not open I just want to open the
addin and Excel at the same time. Is there a way to do this through VB or
VBA? This would be similar to say double clicking on the XLA through
explorer.

I've not used Lookup before and having troble to get it to work with th
following table.
Sheet 1
A1 = bus123

I have exhausted my search abilities to find an answer to what should be
a simple question.
I created a user form that pretty much duplicates the built in Data
Form.  The major difference is that it does not contain all of the

Can somebody please explain me how to store jpg's in a database and le
them show in another sheet when entering a specific key
--
Marc Willems

I am creating an appointment book and want to accomodate the extra day every
leap year. If D3=2006 than D35=1 March but if  D3=2008 it must be 29 Feb. I
need two formulars in one cell to accmodate the variation in D3. Can anybody
help?

I'm a novice to excel and am trying to make up a leave form. I have
column for time leave started (in hours) the next column is the dat
next column is time returned (in hours) then next column is dat
returned. I also have set up a list of public holidays. I then have

Is here a simple way to format a cell which contains an email address as
pure text - That is, so that clicking on the cell won't bring up the email
program to open a new email?

I receive a weekly report from our IT and the digits (in general format
and align to the left though ) cannot be changed to ordinary numbers so
that I can sort them in A-Z. When I highlight the whole digit column
and format it to Numbers,nothing change. I am running Office 2000 and

i need to sort a column for addresses. i can get it to sort somewhat.
example
n 7 ave e
n 7 ave w

I am trying to sort faculty records by position in Excel and am having some
trouble. The usual sort options don't seem relevent, so I have a hunch that I
need to configure a custom list. I would like the records to appear in the
following order: Full, Associate, Assistant, ...