ddd format to 'text' field

R

rrupp

I have a column of data formatted as ddd for custom, Wed, for example. I
created another column to copy the data into, for charting purposes, and want
it to appear as 'Wed' in text format, not 6/13/2005 as it is in the other
column. Any suggestions?
 
D

Dave Peterson

=text(a1,"ddd")


I have a column of data formatted as ddd for custom, Wed, for example. I
created another column to copy the data into, for charting purposes, and want
it to appear as 'Wed' in text format, not 6/13/2005 as it is in the other
column. Any suggestions?
Click to expand...
 
Top