Thanks for the help! You replied to my problem of getting a date to convert to text.
hermanlaksko (Programmer) Feb 5, 2002
=format(Month(now()),"00"
will do the trick
am I over stepping my bounds if I ask one more favor?
When I tried putting the "Year" in the formula {=format(Year(now()),"00"} i got "2002". How do I get it to be "02" as the displayed text? I tried playing with it but no luck.
I would appreciate any help.
thanks steve
hermanlaksko (Programmer) Feb 5, 2002
=format(Month(now()),"00"
will do the trick am I over stepping my bounds if I ask one more favor?
When I tried putting the "Year" in the formula {=format(Year(now()),"00"} i got "2002". How do I get it to be "02" as the displayed text? I tried playing with it but no luck.
I would appreciate any help.
thanks steve
