work with strings/numbers and dates

[William DeLeo]

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

 

[Norman Jones]

Hi William,

Try:

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

 

[William DeLeo]

Thanks so much!!