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)
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)
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)
Great thanks. For the format sting I used 00\:00 and that gave me exactly what I needed.