Spreadsheet: Motoring Computer Related forum

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

Forum Version 3.0 - By Khoosys