Try =Text(today(),"yyyymmdd")

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Adam1 Chicago" wrote in message
...
Gary,
Thanks -- that get it to the right format. However, I am using the date
in
this format as an input to a formula in Excel which pulls some data from
Bloomberg and I need to somehow transform the date into text, because as
long
as its VALUE appears as 38398 Bloomberg can't recognize it. It's looking
for
the text of 20050223 and I am trying to figure out a way to have my Excel
figure today's date as usual (=today()) then have a macro to cut and paste
that date (which we just formatted as YYYYMMDD) as something that looks
the
same but now has the additional property of having a value equal to
20050223.

Thanks,Adam

"Gary Brown" wrote:

FORMAT / CELLS / NUMBER / CUSTOM
yyyymmdd

Hope this helped,
Gary Brown

"Adam1 Chicago" wrote:

How can I get Excel (2003) to display a date as YYYYMMDD with no
hyphens,
periods or dashes between the YYYY the MM and the DD?

I still need the cell to be recognized as a date.

Thanks