Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-11-2017, 02:25 AM
Brey89 Brey89 is offline Windows 10 Office 2016
Join Date: Jul 2017
Posts: 1
Brey89 is on a distinguished road
Default Excel number format

Since I am quite new at all of this so I am asking for your help. I know its so basic but please help.
I am trying to write a number 0001 to excel cell. And continue on with 0002 and so on, but excel turns my number into "1".
How do I costomize format of the number so it will stay

Reply With Quote
Old 07-11-2017, 03:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,230
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

You could
enter the 0001 preceded by an apostrophe,
custom format the cells as "0000" then just enter the number 1, 2 ; etc..
or, supposing you start in row 1 enter the following formula and pull down =text(row(),"0000")
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Old 07-11-2017, 06:35 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

Custom format "0000".

Edit...just read all of peco's post and he covered that.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to format a TOC (level 1) using a number, but have the number hidden in the text porpoiseoil Word 1 09-13-2014 12:53 PM
Change from General Format to number format gbaker Excel 3 08-16-2013 01:04 PM
Custom Number Format for Chart deadrxn24 Word 4 03-18-2012 05:38 PM
Numbering, defining new number format nrschmid Word 0 12-30-2009 03:04 PM
Default Number Format boutells Excel 1 05-20-2009 02:46 PM

All times are GMT -7. The time now is 02:25 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft