Yes. Thats applying a particular format on the value. But to use =TEXT(value,format_text) I will have to provide a specific time format here (format_text). How would I know which specific format is used in source cell.