hello,
i often have the most annoying problem with excel. it automatically decides how to format specific data.
here's one example. i've imported a text file with some timing information in minutes:seconds. every time excel automatically makes it hours:minutes. if i go and format the information to minutes:seconds, the data is then show as incorrect. here's another example. the data is 28:17 (28 minutes, 17 seconds). well, when i import it, the data is now conveted to "01-01-1900 04:17:00". even when i try to copy the format of another cell, it then changes the data to 04:17:00. argh!!! why on earth does excel change 28:17 to a date and a time in 1900?another classic one is if you type 05-09, excel will change it to 05-sep. as if the information is a date in -- 05 september 2003. it's so irritating that it does this.what causes this to happen? why does it automatically decide how toformat the information? whatever it is i would like to turn it off so that excel never formats any data until i tell it to.Do you know about SharePoint?If you know so help me.