--- title: Ahhh, I can't type a phone number in to Excel description: Have you ever tried to enter a phone number or in fact any number that starts with a zero in to Excel? This super quick tip will help. image: https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) # Ahhh, I can't type a phone number in to Excel [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 18 March, 2025 ![](https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg) When you try to enter a phone number in to Excel you will find that Excel removes the Zero from the start of the number. This is because a number cannot start with a zero unless it is decimal. To solve this issue type an apostrophe in front of the number. Eg '01234567 instead of 01234567 and this will mean the zero is kept after you press enter. Previous Post ###### [OOPS I LEFT MY CAPS LOCK ON](https://woodthorpeitsolutions.co.uk/tips-and-news/oops-i-left-my-caps-lock-on) Next Post ###### [The final countdown (Date Maths in Excel)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/The%20image%20shows%20a%20computer%20screen%20displaying%20a%20vibrant%20Excel%20spreadsheet%20with%20a%20dynamic%20table%20format%20The%20table%20is%20neatly%20organized%20with%20alternating%20ro.png?width=352&name=The%20image%20shows%20a%20computer%20screen%20displaying%20a%20vibrant%20Excel%20spreadsheet%20with%20a%20dynamic%20table%20format%20The%20table%20is%20neatly%20organized%20with%20alternating%20ro.png)](https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table) #### [Quickly Format your data as a table](https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Cartoon%20post%20it%20note%20with%20writing%20in%20it%20stuck%20on%20a%20computer%20screen.jpeg?width=352&name=Cartoon%20post%20it%20note%20with%20writing%20in%20it%20stuck%20on%20a%20computer%20screen.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/add-a-comment-to-a-cell-using-a-shortcut) #### [Add a comment to a cell using a shortcut](https://woodthorpeitsolutions.co.uk/tips-and-news/add-a-comment-to-a-cell-using-a-shortcut) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Happy%20person%20sitting%20Infront%20of%20a%20computer%20and%20looking%20relaxed%20cartoon-1.jpeg?width=352&name=Happy%20person%20sitting%20Infront%20of%20a%20computer%20and%20looking%20relaxed%20cartoon-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/drag-and-drop-in-outlook-you-have-the-power) #### [Drag and drop in Outlook - You have the power...](https://woodthorpeitsolutions.co.uk/tips-and-news/drag-and-drop-in-outlook-you-have-the-power) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2025-03-18T14:43:29.530Z", "datePublished" : "2025-03-18T14:43:29.000Z", "headline" : "Ahhh, I can't type a phone number in to Excel", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/i-cant-type-a-phone-number-in-to-excel", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```