| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert a number formated as a date to text in Excel?
I need to convert several columns of dates in excel to text. When I simply
use the format cells command to reformat the cells to text, it first converts the date back to the underlying number then converts it to text. Hope I'm being clear here. Example - the date as viewed on the screen is Mon (Monday). When I convert it to text I get 38446. I want "Mon", in text format. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Threaded Mode
