lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I highlight cells A1:A3 and changed the format to Text. Then I entered time
<tbody>
</tbody>
They are all aligned to the left. So far so good. Then I highlighted them again and changed the format to Time.
Nothing changed!!. What I needed to do is to double click on each cell, for example I double clicked on cell A1
then the value would change to 1:00:00 AM.
Why when I highlighted the cells and changed the format to Time, nothing happened? When I needed to double click on each cell to make the change happen? thank you very much.
I highlight cells A1:A3 and changed the format to Text. Then I entered time
1:00 |
2:00 |
3:00 |
<tbody>
</tbody>
They are all aligned to the left. So far so good. Then I highlighted them again and changed the format to Time.
Nothing changed!!. What I needed to do is to double click on each cell, for example I double clicked on cell A1
then the value would change to 1:00:00 AM.
Why when I highlighted the cells and changed the format to Time, nothing happened? When I needed to double click on each cell to make the change happen? thank you very much.