Computer Related > Spreadsheet Miscellaneous
Thread Author: Robin O'Reliant Replies: 2
View Threaded 

 Tue 14 Oct 14 16:31 
 Spreadsheet - Robin O'Reliant
Can anyone tell me how to start a number with an 0 on a spreadsheet (Open Office)?

Ta.
Reply to this message | Report message
       
 Tue 14 Oct 14 16:42 
 Spreadsheet - CGNorwich
Highlight the cell and right click Go into format, select number and in the options you will see "leading zeros" If you want a four digit number to start with a zero select "5"
Reply to this message | Report message
       
 Wed 15 Oct 14 11:47 
 Spreadsheet - Robin O'Reliant
Thanks GC.
Reply to this message | Report message
       
Latest Forum Posts