ExcelBanter - hello! and heelp

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - hello! and heelp (https://www.excelbanter.com/excel-worksheet-functions/140511-hello-heelp.html)

MANU

hello! and heelp

how to transform a number into a date?

joel

hello! and heelp

=datevalue("4/27/07")

"manu" wrote:

how to transform a number into a date?

Bob Phillips

hello! and heelp

Just format the cell as a date format.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"manu" wrote in message
...
how to transform a number into a date?

Dave Peterson

hello! and heelp

What do the numbers look like?

manu wrote:

how to transform a number into a date?

--

Dave Peterson

All times are GMT +1. The time now is 05:20 PM.