| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numbers as Text
I want to convert the number 12345678, etc. into Text with 10 digits, with
leading zeros, when necessary, i.e. 0012345678. I first formatted the 8 digit number to a 10 digit one with the Format Cells Dialog Box (0000000000) and then format it as Text. But whenever I do that, the leading zeros get lost and the values remain numbers! How can I format the Cells that the values remain "0000000000" (=text) Felix |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Numbers as Text
In a helper cell...............
=TEXT(12345678,"0000000000") Or =TEXT(cellref,"0000000000") Gord Dibben MS Excel MVP On Mon, 4 Aug 2008 20:59:01 -0700, Felix wrote: I want to convert the number 12345678, etc. into Text with 10 digits, with leading zeros, when necessary, i.e. 0012345678. I first formatted the 8 digit number to a 10 digit one with the Format Cells Dialog Box (0000000000) and then format it as Text. But whenever I do that, the leading zeros get lost and the values remain numbers! How can I format the Cells that the values remain "0000000000" (=text) Felix |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
