refering to contents of cell as opposed to cell number

K

Kris

Hello, I need to plug the contents of a cell for a DATEVALUE function. So I
need to get the date e.g. sep 13, 2003 as opposed to "C6". How would I do
this?

I need one column to show actual dates and I need another column to convert
those dates to Excel time code for other functions.

Thanks,

Kris
 
T

Tom Ogilvy

format the cell as General. If the value in the cell looks like 37887 or
37887.023435

then the cell already contains an excel time code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a number into a cell reference 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Count Dates in a range based on Column Header Id without using sum-product 1
Changing contents of cell based on Cell Format 3
Different answers when using cell references as opposed to actual 4
Conditional Formatting - to highlight overwritten formulas 13
Show value from one cell in another cell if today falls between a date range 5
cell reference of a formula 2

Top