ExcelBanter - ddd format to 'text' field

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ddd format to 'text' field (https://www.excelbanter.com/excel-discussion-misc-queries/39318-ddd-format-text-field.html)

rrupp

ddd format to 'text' field

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?

Dave Peterson

=text(a1,"ddd")

rrupp wrote:

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?

--

Dave Peterson

All times are GMT +1. The time now is 11:18 AM.