If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Leading Zero as value not appearance
When i use formatting cell custom with 0000 i manage to add leading zero but
the problem is the leading zero only as appearance. Is it possible to make it as value in the cell |
#2
|
|||
|
|||
Leading Zero as value not appearance
Format the cell as Text.
Select the RangeDo Right ClickFormat CellsNumberCategoryText and give ok. Now input your leading zero value in the text formatted range. But the Values are not treated as real numbers and it is considered as Text Values. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "zyus" wrote: When i use formatting cell custom with 0000 i manage to add leading zero but the problem is the leading zero only as appearance. Is it possible to make it as value in the cell |
#3
|
|||
|
|||
Leading Zero as value not appearance
2 options.
You want value of 0123 in A1 Precede 0123 with an apostrophe. OR in an adjacent cell =TEXT(A1,"0000") Gord Dibben MS Excel MVP On Tue, 1 Jun 2010 01:28:05 -0700, zyus wrote: When i use formatting cell custom with 0000 i manage to add leading zero but the problem is the leading zero only as appearance. Is it possible to make it as value in the cell |
Thread Tools | |
Display Modes | |
|
|