can someone give me the formula for converting from a julian date to a
standard mm/dd/yy year formt

I am taking over a spreadsheet that has a list of options that is specific to
one name in it.  Currently when you choose this guy's name, the user has to
hunt and peck for the choices that are specific to him.
Is there a way that I can force Excel to display just those choices ...

I have mutiple worksheets with daily information covering 6 months. I have
set up formula that highlights  column with "today" realting to current date.
I would like to set up macro on each worksheet that I can run to take me to
"todays" date

I have a workbook that I use to keep track of individulas time worked on
specific jobs. One sheet per person.  On anygiven sheet, I have a list of
jobs in Column A and hours worked on these jobs entered in following columns
with the "weeks end" date as the column heading.  At the ...

I know this can be done, I just can remember how or seem to be able to find
it under help.
I would like the border around my active cell to be a different color so it
stands out easier than the now black border on an all black text document.  I

If the date in cell C3 is after date in cell C1, then color cell orange.
If this is possible then can I do this:
If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell

This is almost what I need but can anyone help please. I need for it to COPY
"Sent to Assembly" sheet each time something is added(Columns A, B, C and
sent to Sheet1. Right now it only copies Column A. Also should this go in a
Module or a worksheet function? Thanks in advance

when working out a time sheet for example, i want to be able to enter time
using a decimal point (.) instead of a colan(:) and be able to add them
together to get  decimal hours.
ie. start 8.00 (8:00) finish 3.45 (15:45) minus .30minutes (0:30) = 7.25

I need to add several angle measurements in dd-mm-ss format. How do I enter
these into excel cells and have them work? I saw postings from a year ago but
couldn't get it to work.
Office excel 2003

I have a column in a large spreadsheet called "warehouse". "Warehouse" (A2
thru A7500) can be one of 25 possible names (MOreturns, MOinv, MOjunk,
TXreturns, TX2returns, TXjunk, AZreturns, AZ2, etc.). I am inserting a column
(B) where I want the warehouse location to populate ...

Hi
I have created a shared workbook, protect 5 individual sheets in the
workbook and allow some users to update sales data only while protect
formulas. I have also assigned a routing recipient function to the workbook,

I have a spreadsheet for work orders. The columns are WO#, Date, Planner,
Vendor, Bldg, Room, Equip#, Date Entered, PO#. Each Planner uses the
automatic filter to see the line items that belong to them. They then would
like to be able to sort by vendor alphabetically. This is the ...

Good Afternoon All,
I have a function built that takes a character based coded cell value and
reformats into a number with a formula.
The function works fine manually using it example =BigBookingNumber(cell

I have three columns of numbers Column A  = 9101-9120,   Column B =
9121-9140, and Column C = 9141-9160.  I need to randomize columns B & C
seperately, but with the numbers that are already in the columns.  Can I do
this somehow?

I have a problem where sometimes when I try to enter a number in the format:
1-4-1 in a cell, it automatically enters different number such as 35639. I
cannot find any hidden formulas, or conditions, and it doesn't happen in
every cell.Anyone have any ideas about what could be ...