| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
| How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
| format cells having text | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| How do I format email addresses as Text only? | Excel Worksheet Functions | |||
Linear Mode
