Date to Text

[tobriant]

I need to turn a date into text. For example, I am using the custo
format dddd for a block of cells, which returns the day name of th
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 nam
of the day, not the value. Any suggestions

 

[Bernie Deitrick]

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