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
|