Different date behaviour in different computers
Hi,
One of my friend experienced this and told me over the phone. He has a computer with XP and Office 2002. In cell A1 he has a date (lets say entered using Ctrl + ;) In cell A2 he writes a formula ="As on "&A1 The result displayed is As on 38244 (I know that excel represents date as numbers etc and the above may be overcome using ="As on "&TEXT(A1,"mm-dd-yy") But again my query is different.) My friend has a colleague who has a computer with 98 and Office 2000. His colleague works on the same file and in Cell A1 has a date. In A2 his colleague enters ="As on "&A1 The result displayed is As on 09-14-04 Why are the 2 results displays different? Regards, Hari India |
All times are GMT +1. The time now is 10:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com