• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to stop excel from automatically changing the format of the cells

S

sonam123

New Member
Hello Everyone!
First of all thanks for reading this post.

So I have this file which includes a column date that is in the "unix timestamp" data type.
After I download this file and open it in my Excel what I see is that excel automatically adds zeros at the end of the cell value making it hard for me to get the actual exact value.

So, is there any way to possibly stop the excel from automatically changing the cell value the moment I open the excel or If it is possible to restore the actual value. Do let me know.

Thanks

ex. cell value get converts into value like "1682965800000" and actual value is like "1690285439"
 

sonam123​

How do You know ... what is actual value like "1690285439"? ... text?
What is in that cell?
... it can be different than You see.
Could You send a sample file (after You've downloaded something - before You've opened it with Your Excel)?
... that others could see - what is going on?
There are basic formulas ( use Google ) to get "Unix timestamp" for Excel and back.
 
You must log in or register to reply here.
Back
Top