Thread
:
=Text(n,"mmm") always returns "Jan" when n=1..12
View Single Post
#
13
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_]
external usenet poster
Posts: 1,231
=Text(n,"mmm") always returns "Jan" when n=1..12
"T. Valko" wrote...
Here's how it works...
**Only works using the default date system.
1*30 = serial date 30 = Jan 30 1900
....
Right, so use 29 as the multiplier and it works in both date systems.
Reply With Quote
Harlan Grove[_2_]
View Public Profile
Find all posts by Harlan Grove[_2_]
=Text(n,"mmm") always returns "Jan" when n=1..12