> -----Original Message----- > From: [email protected] > Sent: Sun, 30 Aug 2009 17:54:59 +0530 > To: [email protected] > Subject: [discuss] FORMAT CELL FEATURE > > I have started using OPENOFFICE.ORG. CALC. > > I wish to enter time 14:15 in 1415 format. > > How can i do that. > > Deepak Goyal
After selecting the cell to be formatted, right click on it. That should get you the "Format Cells" menu. Then select the "Numbers" tab, and then "Time". That will give you all the default formats for time data. If you really want to get rid of the colon, then you will need to customise the format you select in the "Format code" box at the bottom of the menu. Be aware that you will still need to use the colon when entering the Time, even though the custom formatting will block it from being visible. Kirk ____________________________________________________________ GET FREE 5GB EMAIL - Check out spam free email with many cool features! Visit http://www.inbox.com/email to find out more! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
