trekcowboy
New Member
- Joined
- Mar 5, 2002
- Messages
- 9
does anyone have a formula for converting numbers to dates.
ex. 03282002 = 03/28/2002
Thanks
ex. 03282002 = 03/28/2002
Thanks
On 2002-03-28 12:21, trekcowboy wrote:
does anyone have a formula for converting numbers to dates.
ex. 03282002 = 03/28/2002
Thanks
On 2002-03-28 12:21, trekcowboy wrote:
does anyone have a formula for converting numbers to dates.
ex. 03282002 = 03/28/2002
Thanks
On 2002-03-28 12:34, trekcowboy wrote:
thanks to both of you, what if the month is not always two digits.
on my spreadsheet excel is dropping the leading 0
3282002
thanks again
On 2002-03-28 13:12, Mark W. wrote:
Use =TEXT(REPT(0,8-LEN(A10))&A10,"00-00-0000")+0
On 2002-03-28 13:14, Juan Pablo G. wrote:
On 2002-03-28 13:12, Mark W. wrote:
Use =TEXT(REPT(0,8-LEN(A10))&A10,"00-00-0000")+0
Mark, just confirming, this assumes that the Date system uses mm-dd-yyyy right ?