work with strings/numbers and dates
 

Hello (again),

I am trying to define a cell value as a fabricated number derived fro
today's date.

For example:

I'd like to set a cell's contents equal to "20040504.01", derived fro
todays date (2004/05/04) and a running number 01.

I'd like to start with the TODAY() function and somehow maniuplate th
characters into a number and tack on a two digit number to the end as
decimal.


Hmmm.

Thanks so much... You guys rock

--
Message posted from http://www.ExcelForum.com

work with strings/numbers and dates
 

Hi William,

Try:

aStr = Format(Now, "yyyymmdd") & ".01"

---
Norman

"William DeLeo " wrote in
message ...
Hello (again),

I am trying to define a cell value as a fabricated number derived from
today's date.

For example:

I'd like to set a cell's contents equal to "20040504.01", derived from
todays date (2004/05/04) and a running number 01.

I'd like to start with the TODAY() function and somehow maniuplate the
characters into a number and tack on a two digit number to the end as a
decimal.


Hmmm.

Thanks so much... You guys rock!


---
Message posted from http://www.ExcelForum.com/

work with strings/numbers and dates
 

Thanks so much!!

--
Message posted from http://www.ExcelForum.com