Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2017, 02:25 AM
Brey89 Brey89 is offline Excel number format Windows 10 Excel number format Office 2016
Novice
Excel number format
 
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 Excel number format Windows 7 64bit Excel number format Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-11-2017, 06:35 AM
gebobs gebobs is offline Excel number format Windows 7 64bit Excel number format Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
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
Excel number format 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
Excel number format Default Number Format boutells Excel 1 05-20-2009 02:46 PM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft