I am currently trying to do a time management grid in excel, but everytime i try and put in 0000 it just turns into a 0 . I have tried to format the cell but to no avail!! Help x
2007-10-03 01:44:07 · 9 answers · asked by dizzymooo 4 in Computers & Internet ➔ Software
Right-click on cell, choose "Format cells"
Click "Number" tab
Choose "Custom" in the list of categories.
On the "Type:" blank, please type 0000
Click OK
See if that works for you.
:)
2007-10-03 01:51:39 · answer #1 · answered by espresso star 2 · 2⤊ 1⤋
you can format the cell to show as a 4 digit number - go to Format - Cell - Number - and choose Custom from the list, then it should give you a box at the top under Type: and if you type in there 0000 then press OK, it will stay like that in number form
2007-10-03 01:54:42 · answer #2 · answered by Damia 3 · 2⤊ 1⤋
If you dont want decimal points and youre not doing calculations you could always format the cells as text, or under format cells, number, click on custom and set up a custom format just how you want.
2007-10-03 03:19:18 · answer #3 · answered by Anonymous · 0⤊ 0⤋
You need to format your cells with a custom format.
Select custom, then for your format enter either:
hh:mm - for hours and minutes
or
mm:ss - for minutes and seconds
If you are needing a decimal, pick the number format and set the number of decimal places to 4 or however many decimal places you need.
If you have trouble, go to Excel's help and do a search on "custom formats". Then select "Guidelines for custom number formats". In the help window that pops up, go to "Dates and Times" then select "Displaying hours, minutes, and seconds".
2007-10-03 02:50:30 · answer #4 · answered by devilishblueyes 7 · 0⤊ 0⤋
If you are not doing calculations, format the cells as text.
If you are doing time calculations and set the format for time, just remember the format looks like hours and minutes, it is really the time of day as a fraction of a day, you may need to factor it by 24 to decimalise.
2007-10-03 23:33:09 · answer #5 · answered by colin cc 2 · 0⤊ 0⤋
You can also use the time() function
To put in 0000 as a time into excel type:
=time(0,0,0)
The time function allows you to enter other times too; for example, 10.25 would be =time(10,25,0) or 10hr 25 mins and 30 seconds would be =time(10,25,30).
2007-10-03 01:50:37 · answer #6 · answered by Creative-Petel 1 · 1⤊ 2⤋
Format the cell as Time and you will get 00:00
2007-10-03 01:48:37 · answer #7 · answered by Robin the Electrocuted 5 · 2⤊ 2⤋
Try putting a period before you add 0000. That should work
2007-10-03 01:48:16 · answer #8 · answered by Another One 1 · 0⤊ 2⤋
Stick a ' character at the front of the data.
2007-10-03 01:47:13 · answer #9 · answered by David D 7 · 0⤊ 5⤋