#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Custom format "0000".
Edit...just read all of peco's post and he covered that. |
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 |