Formating cells or row ?.

**Ice Can-Am** · 06-23-2009, 07:55 PM

Hello i am a new guy here and i have some questions for you. I have made a screenshot of a work sheet i have made see here \1

and the questions are can i format the cells that i have made grey for this photo to automatic put : between numbers i put in like the time.example if i would put in a cell 1200 than it would be like 12:00 is that possible i have been through all the time formats in the format cells options but i always get this result ###.

the other ? is can i take the S away when i have formated cells to show kilograms so it would be like 550 kg instead of 550 kgs ?

Thanks.
if the link does not work above than try this one. http://www.postimage.org/image.php?v=aV1kkc2i

**CRIMEDOG** · 06-23-2009, 11:15 PM

if you are getting #### it generally means that the column is not wide enough.

**Ice Can-Am** · 06-24-2009, 08:03 AM

ramp info.xls

My first time here so i don't know if i done it right hehe.

Ok it worked it has been uploaded.

**Ice Can-Am** · 06-24-2009, 05:33 PM

That would be under the ARR cell D8 - D14 and under the DEP cell F8 - F14.

**martindwilson** · 06-24-2009, 07:08 PM

for kg custom format cell 00Kg or 00 Kg
entering time as 1200 isnt going to work as time but you can custom format as 00":"00
ie 1235 would still be that value but would look like 12:35

**Ice Can-Am** · 06-24-2009, 07:31 PM

Originally Posted by martindwilson

for kg custom format cell 00Kg or 00 Kg
entering time as 1200 isnt going to work as time but you can custom format as 00":"00
ie 1235 would still be that value but would look like 12:35

Thank you so much this is exactly what i was looking for it saves me a lot of time when i am on duty.Now i can just pick in numbers an don't have to worry about the :