| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a Date to Text?
A date formatted field displays in cell N2 "2006". I need the text version
of this to display exactly the same, "2006" with no date serial lurking in the background. My formula does not work... displays the text value of the formula itself... =TEXT(N2,"mmm/ddd/yyyy"). How can I create a Text value of 2006? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a Date to Text?
On Wed, 8 Mar 2006 16:59:27 -0800, Dave76Mizzou
wrote: A date formatted field displays in cell N2 "2006". I need the text version of this to display exactly the same, "2006" with no date serial lurking in the background. My formula does not work... displays the text value of the formula itself... =TEXT(N2,"mmm/ddd/yyyy"). How can I create a Text value of 2006? Thanks. =TEXT(N2,"yyyy") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
| Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
| Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
| How to convert DATE and TIME to text | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
