ylittlejohn
New Member
- Joined
- Mar 26, 2002
- Messages
- 5
If I type a date 32702 in the cell, how can I get it to display the correct date of 3-27-02. In other words I would like to not have to type the dash. Is it possible? Thanks
On 2002-03-27 16:13, ylittlejohn wrote:
Thanks but when I enter 22702 that gives me the date of 7-13-89. What have I done wrong?
On 2002-03-27 16:17, IML wrote:
On 2002-03-27 16:13, ylittlejohn wrote:
Thanks but when I enter 22702 that gives me the date of 7-13-89. What have I done wrong?
You could use a formula
=DATE(2000+RIGHT(A1,2),LEFT(A1,1+(LEN(A1)>5)),MID(A1,2+(LEN(A1)>5),2))
assuming all your dates in 2000.
This will conver your numbers into dates.
Excel treats time as fractions of day. 1 = 1/1/1900 to most excel users. So today is 37,342 and 32,702 is some previous date
Better option: Text to columns.
Highlight row - data - text to columns - next, next again, click date MDY.
For text to column or formula to work you must enter a two digit day.
This message was edited by IML on 2002-03-27 16:22
On 2002-03-27 21:16, nisht wrote:
Make a custom format..
First select date and then custom
Now in type give value
dd mm yy
or
dd mm yyyy
ni****h desai
http://www.pexcel.com