Starting cell with a 0

General discussion on OpenOffice Calc and its spreadsheets.

Starting cell with a 0

Postby Tansenn » Mon Aug 04, 2014 10:57 am


I'm trying to start a cell with a 0. The 0 is required to be in front of 7 other digits for some fields. In Excell I would just set the cell to plain text, but I have not been able to figure it out. I'm looking for the results of 012345678

Posts: 28
Joined: Tue Mar 25, 2014 6:27 am

Re: Starting cell with a 0

Postby Bryan L. Warfield » Mon Aug 04, 2014 12:04 pm


If you are working in Base the data type of the column needs to be set to a text type such as VARCHAR.

I hope this will helps you
Bryan L. Warfield
Posts: 29
Joined: Mon Mar 24, 2014 6:11 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 2 guests