| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 questions on appearance | Excel Discussion (Misc queries) | |||
| appearance of a concatenated value | Excel Worksheet Functions | |||
| Excel Appearance | Excel Discussion (Misc queries) | |||
| Cell appearance | Excel Discussion (Misc queries) | |||
| Cursor Appearance | Excel Discussion (Misc queries) | |||
Hybrid Mode
