ddd format to 'text' field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

condionally formatting based on another cells formatting? 2
Changing dates to date format 5
Conditional Format Date/Day (ddd)? 1
Weekend dates conditional format 3
Can I get date in this format? 1
Formula for formatting rows and columns minimizing the outcome. 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Format cells to show dates as the day of the week 3

Back
Top