Using open office, spreadsheet... I want to display time in a column of cells... as 14:00 but the default is showing 14:00:00
I have tried to change it,....but cannot get it to work using the toolbar or the "format" .. please can someone point me to the right thing to click on !
Fixed! Go to the fix.