Thread: Date fomula not working
View Single Post
  #23  
Old February 16th, 2009, 03:26 PM posted to microsoft.public.excel.worksheet.functions
FangYR
external usenet poster
  
Posts: 18
Default Date fomula not working
column A was format as "date"
--
Regards
FangYR
Malaysia


"Glenn" wrote:

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.