text to time

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Thank you. But let me explain why I am confused about this. Let say A1 value is 1

I click on A1 and change the format to Short date, I will get 1/1/1900
then I click on the A1 again and I change the format to General and I will get 1

So I did not need to double click on A1 to change 1 to 1/1/1900 or 1/1/1900 to 1

Why with the time I had to double click on the cell? Thank you.
 
Upvote 0
But why I need to re-enter them. They are already there. Let say I have 100 of them. Do I need to re-enter them again. Thank you very much.
 
Upvote 0
test it: enter time, change format to text, then change format to general then change format to time. don't change format of the cell before entering time

if you want more use Alt+Q or F1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top