Date to Text
 

I need to turn a date into text. For example, I am using the custom
format dddd for a block of cells, which returns the day name of the
date entered (e.g., 8/5/05 returns Friday). I need to turn the "Friday"
into text, so the date value is no longer associated.

Main goal, I am making a calendar for access, and want the actual name
of the day, not the value. Any suggestions?


--
tobriant
------------------------------------------------------------------------
tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155
View this thread: http://www.excelforum.com/showthread...hreadid=393337

tobriant,

Select your cells with the day names, and run this macro:

Sub TryNow()
Dim myCell As Range
For Each myCell In Selection
myCell.Value = myCell.Text
Next myCell
End Sub

Or, use a formula in another block of cells:

=TEXT(A1,"dddd")

and copy down, then copy / pastespecial values over the original data.

HTH,
Bernie
MS Excel MVP


"tobriant" wrote in message
...

I need to turn a date into text. For example, I am using the custom
format dddd for a block of cells, which returns the day name of the
date entered (e.g., 8/5/05 returns Friday). I need to turn the "Friday"
into text, so the date value is no longer associated.

Main goal, I am making a calendar for access, and want the actual name
of the day, not the value. Any suggestions?


--
tobriant
------------------------------------------------------------------------
tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155
View this thread: http://www.excelforum.com/showthread...hreadid=393337