Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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


Hey.
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

thanks
Reply With Quote
  #2  
Old 07-11-2017, 03:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
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
Default

You could
enter the 0001 preceded by an apostrophe,
or
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
  #3  
Old 07-11-2017, 06:35 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Custom format "0000".

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

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.
MSOfficeForums.com is not affiliated with Microsoft