So it would be MARCH 16, 2007, for example?

thanks!

=UPPER(TEXT(TODAY(),"mmmm dd, yyy"))
--
Gary's Student


"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

This works great for today's date- actually I didn't explain quite right- can
I format so that whatever date I enter in the cell will show the month in all
caps?

thanks again~

"Gary''s Student" wrote:

=UPPER(TEXT(TODAY(),"mmmm dd, yyy"))
--
Gary's Student


"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

So...does this mean there's no way to do it so that Excel still recognizes it
as a date?

thanks again~

"CLR" wrote:

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

Excel can convert date text to system dates. Try this:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Where Cell A1 contains the text MARCH 17, 2007

"lamersn" wrote:

So...does this mean there's no way to do it so that Excel still recognizes it
as a date?

thanks again~

"CLR" wrote:

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

That formula gives #VALUE, if A1 contains text.
--
David Biddulph

"Mike Campbell" wrote in message
...
Excel can convert date text to system dates. Try this:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Where Cell A1 contains the text MARCH 17, 2007

"lamersn" wrote:

So...does this mean there's no way to do it so that Excel still
recognizes it
as a date?

thanks again~

"CLR" wrote:

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer dates
as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

Thanks though- I already have the date in the cell I used the formula from
CLR on- was looking for something that would show the date with the month in
caps and still be recognized by Excel as a date~



"Mike Campbell" wrote:

Excel can convert date text to system dates. Try this:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Where Cell A1 contains the text MARCH 17, 2007

"lamersn" wrote:

So...does this mean there's no way to do it so that Excel still recognizes it
as a date?

thanks again~

"CLR" wrote:

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

The all caps date is for display, right? Make one table for display, and
somewhere else have a table that Excel can use for calculations. The extra
cells you need are cheap, especially compared to the effort it would take to
force one cell to fulfill two contradictory roles.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"lamersn" wrote in message
...
Thanks though- I already have the date in the cell I used the formula from
CLR on- was looking for something that would show the date with the month
in
caps and still be recognized by Excel as a date~



"Mike Campbell" wrote:

Excel can convert date text to system dates. Try this:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Where Cell A1 contains the text MARCH 17, 2007

"lamersn" wrote:

So...does this mean there's no way to do it so that Excel still
recognizes it
as a date?

thanks again~

"CLR" wrote:

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL

VALUES on the column..........."but" they are now TEXT, no longer
dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!

Maybe use two columns, one with the TEXT date the way you want to see it,
and another with the real Excel date to manipulate as you wish as a
date...........

hth
Vaya con Dios,
Chuck, CABGx3


"lamersn" wrote in message
...
Thanks though- I already have the date in the cell I used the formula from
CLR on- was looking for something that would show the date with the month
in
caps and still be recognized by Excel as a date~



"Mike Campbell" wrote:

Excel can convert date text to system dates. Try this:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Where Cell A1 contains the text MARCH 17, 2007

"lamersn" wrote:

So...does this mean there's no way to do it so that Excel still
recognizes it
as a date?

thanks again~

"CLR" wrote:

=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY
PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer
dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!