Forum Discussion
Solved
Inputting formated numbers
Help Please- I have a lot of time data to enter in an Excel Spreadsheet. I would like to type 0955 to then appear as 09:55 in my worksheet. I know I can use a Custom format to display the data but I ...
- right mousekey
Format cells
Custom
Type:
00 \: 00
OK
Should work without problems, if not please inform again.
If it works, please mark it as the correct answer so that other who interested to know it too ... best with thumbs up (like) 🙂
Nikolino
I know I don't know anything (Socrates)
Hello, using Custom Formatting is still the best option to go with. Having to type colon for each of the entry is time consuming. Just my opinion