| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates converted into text
I receive Excel data from my branch offices.the data should contain
date coloumns.But some cells contain dates in "<year<month.<date" format i.e.,21/02/2010 in dd/mm/yyyy format is displayed as 20100221.Why it is happening?How to convert them into dd/mm/yyyy format? I tried to record and run a macro to insert "/" between year and month and between month and date,then clicking "Enter" button...But,it displays same date in all the cells in which I run the macro. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel converted numbers to dates suddenly in All Sheets!!!! | Excel Discussion (Misc queries) | |||
| Numbers converted to Text | Excel Discussion (Misc queries) | |||
| Text Converted to a Picture | Excel Discussion (Misc queries) | |||
| Text is being converted to Date | Excel Worksheet Functions | |||
| How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) | |||
Threaded Mode
