Format Cell Same As Copy From PDF

Hello people,

I copying some figure from PDF file to excel sheet. In PDF the number in minutes format e.g 27:29
but when in excel is shown as 27:29:00 and cell format show as 1/1/1900 3:29:00 AM. How do I make excel cell same format as copied from pdf?

Thanks.

I know what is happening, but I don't know how to stop it!

Excel sees the colon : an assumes it is time! The first numbers being hours.

You can fix it through a calculation in a new column. Just divide by 60, and format the cell as "MM:SS"

OR you can use this formula =TIMEVALUE("00:" & TEXT(A1,"[hh]:mm")) but not much is gained by this since the other is much simpler, and easy to understand.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".