why number stored as [h].mm.ss

[triaji]

Dear all,

Please help, i have a data from system it shown like date and time. I can't lookup the data.

I attached as sample, thanks.

Regards

[Phuocam]

Try this ...

=TEXT(D4,"[h].mm.ss")

[alansidman]

change your custom formatting as shown belowCapture.JPG

[triaji]

Try this ...

=TEXT(D4,"[h].mm.ss")

Thank you,
I tried and its work, but when i copy paste value, i click the cell it chance to [h].mm.ss again.

[triaji]

[QUOTE=alansidman;4786264]change your custom formatting as shown below[QUOTE]

Thank you, but the format is already like your attachment and its not chance anything

[alansidman]

Thank you, but the format is already like your attachment and its not chance anything

strange as it changed for me.

Data Range

	D
3	KODE
4	6001.01.00
5	6100.01.01
6	6700.01.00
7

[triaji]

[QUOTE=alansidman;4786269]strange as it changed for me.


Or maybe because i using regional setting in my country (Indonesia) like (.) become (,)
By the way, how i add apostrophe (') in the front of numbers, so the result become like "'6001.01.00" is it any formula?