| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to format date as text without changing appearance?
I have a column of 10900 cells with dates of the form
13-May-05. Excel automatically interpreted them as dates when I imported the data from a text file. Now I want them to be interpreted as text. The problem is: when I change the format to "text", the cell content changes to a number. For example, 13-May-05 becomes 38485. Hindsight being 20-20, I should have entered the dates in the form '13-May-50. But it is too late for that now, I think. How can I change the cell format to the text 13-May-05 without manually changing all 10900 cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
| Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Threaded Mode
