Thread
:
how to change number to date
View Single Post
#
4
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
how to change number to date
This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000")
and formatted as a date
Happy One wrote:
How to change the number 1122008 to 1/12/2008?
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson