View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Finding Date in an overseas format

Nope, they are dates. What looks like 12/31/2012, when formatted as "general", shows 41274.

Every single solution provided works for me, here in the US, and for other beta testers in the US. I also sent the spreadsheet to another user in Australia, and he comes up with the same "Date not found" error message. So I've ruled out a problem with the India user's individual computer.

Haven't tried Witek's offering yet - that's next. Will report back.

Could it possibly be something to do with their non-standard Windows OS? I know the user in India uses "Windows Ultimate".

Thanks for all the help.
Susan


On Monday, January 7, 2013 2:30:37 AM UTC-5, Claus Busch wrote:
Hi Susan,



so all solutions don't work I think the values in the india file *looks*

like dates but they are *strings*





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2