View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William DeLeo William DeLeo is offline
external usenet poster
 
Posts: 1
Default 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