Thread
:
Date fomula not working
View Single Post
#
22
February 16th, 2009, 03:13 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
Posts: 1,245
Date fomula not working
FangYR wrote:
A2, 1/3. G2, 693231.
Your entry of 1/3 in A2 is being evaluated as .3333333 (1 divided by 3). Either
enter an apostrophe in front ('1/3) or pre-format the cell as date.
Glenn[_6_]
View Public Profile
View message headers
Find all posts by Glenn[_6_]
Find all threads started by Glenn[_6_]