View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
help help is offline
external usenet poster
 
Posts: 67
Default type in 4-7 changes to 38814

Hi, I was just curious. First, is this bug ever going to be fixed. Second,
how does 4-7 get interpretted as 38814 when switching from date format to
text format, and why? I cannot follow the logic, please help it is really
bugging me.