Hi,
When we want decimals, we could set it in excel. Is there any mechanism, in excel, that if i select time format , 01:30 pm, and then enter 0130, it should change itself to 01:30, without manually typing : character. It takes a whole of time to have the time format and then type in each cell. Anybody having solution pl