Time Format of cell does not update until I double click on cell. - Page 2

Thanks Thanks:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Time Format of cell does not update until I double click on cell.

  1. #11
    New Member
    Join Date
    May 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Time Format of cell does not update until I double click on cell.

     
    You are great man schielrn !

    I am not sure if you will get this reply or not, but i just wanted to let you know you saved a lot of time for me! the date was not updating in a huuugggeeee excel file. made this account just to thank you!!!

  2. #12
    New Member
    Join Date
    Aug 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Time Format of cell does not update until I double click on cell.

    => You must need to convert text format in Target cells
    => If A2 is your target cell then Use This formula right side of the cell (=""&A2)
    => After you get your desire result then drag the whole formula
    => Then copy the formula cells and Paste it in A column as value paste.
    => That's It.
    Note: In formula Don't use () , If you want to use date format then use text formula , like =""&Text(A2,"dd-mm-yyyy")

  3. #13
    New Member
    Join Date
    Feb 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Time Format of cell does not update until I double click on cell.

      
    Quote Originally Posted by schielrn View Post
    Welcome to the Board!

    Set the column to time and then select all the cells in that column. Go to Data-->Text To Columns and press finish. That should get them all in one swoop.

    Hope that helps.

    Thank you!!! I had never even heard of that feature. You just saved me a LOT of work.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com