Do I need the leading 0 in company numbers?

In the United Kingdom, companies register with Companies House and get a Company Registration Number. This unique company number is very useful for understanding who received a grant, when the receiving organisation is a registered company.

In general, the Company Registration Number or the Company Number is a unique combination of numbers but in some cases it includes letters. Quite a few start with a leading zero, for example:

Open Data Services Co-Operative Limited

Company Number 09506232

So, do you need to publish the leading zero? In a nutshell, yes. The leading zero is part of the official number and so needs to be published.

Why does the leading zero disappear?

In spreadsheets like Excel, the column with Company Number might get mistaken for a number, so Excel will drop the leading 0. As you’ll never add, multiply, or do any sort of calculation with a Company Number it should be treated as a string. You can fix this in Excel by formatting the column as text.

Can I just add a 0 to all Company Numbers?

Unfortunately, no you can’t. Sometimes the Company Number starts with a prefix. A prefix tells us that the company is a specific type or based outside England & Wales. So be careful not to add a leading zero where it isn’t needed, for example a Scottish company number begins with SC.