Thread
:
convert 10 as october
View Single Post
#
5
Posted to microsoft.public.excel.misc
Stefi
external usenet poster
Posts: 2,646
convert 10 as october
The number to be converted being in A1
=TEXT(DATE(1900,A1,1),"mmmm")
Regards,
Stefi
€˛Anitha€¯ ezt Ć*rta:
I want to convert number to corresponding month eg., 1 Jan and so on
Reply With Quote
Stefi
View Public Profile
Find all posts by Stefi