i am importing numbers in a classification hierarchy in the form of 00:00.00.
Excel won't accept this format without converting it to some type of time. For instance if my number is 84:24.04, it will convert it to 24:24.04.
That is after I change the standard custom of mm:ss.0 to mm:ss.00. Otherwise it will be something like 24:08.2.
How can I get this to do what i want it to do.
Thanx for you help
Excel won't accept this format without converting it to some type of time. For instance if my number is 84:24.04, it will convert it to 24:24.04.
That is after I change the standard custom of mm:ss.0 to mm:ss.00. Otherwise it will be something like 24:08.2.
How can I get this to do what i want it to do.
Thanx for you help