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 offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,914
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
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")
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: 819
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 06:44 PM.


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