Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bizarre XLA behaviour | Excel Discussion (Misc queries) | |||
2000 shared file excel date format on two different computers | Setting up and Configuration of Excel | |||
for...next funny behaviour | Excel Discussion (Misc queries) | |||
Strange behaviour | Excel Worksheet Functions | |||
Key behaviour | Excel Programming |