| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what function to use
Hello,
This is my row that I want to convert from number to text but with certain criteria: A 1 2 .. .. .. 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance -- H. Frank Situmorang |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
use the following formula:
="0001" & REPT("0",5- LEN(A1))&A1 supposing your data are starting in A1 en copy the formula down -- met vriendelijke groetjes "Frank Situmorang" schreef in bericht ... Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance -- H. Frank Situmorang |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
Frederik:
The result is only 000100000, could you explain more? Thanks in advance -- H. Frank Situmorang "Frederik" wrote: use the following formula: ="0001" & REPT("0",5- LEN(A1))&A1 supposing your data are starting in A1 en copy the formula down -- met vriendelijke groetjes "Frank Situmorang" schreef in bericht ... Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance -- H. Frank Situmorang |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
Frederik
You are awe some, it works perfecly, thank you very much -- H. Frank Situmorang "Frederik" wrote: use the following formula: ="0001" & REPT("0",5- LEN(A1))&A1 supposing your data are starting in A1 en copy the formula down -- met vriendelijke groetjes "Frank Situmorang" schreef in bericht ... Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance -- H. Frank Situmorang |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
-- Don Guillett Microsoft MVP Excel SalesAid Software "Frank Situmorang" wrote in message ... Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance -- H. Frank Situmorang |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
try formatcustom
000100000 -- Don Guillett Microsoft MVP Excel SalesAid Software "Frank Situmorang" wrote in message ... Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance -- H. Frank Situmorang |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
On Thu, 29 Jan 2009 08:12:02 -0800, Frank Situmorang
wrote: Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance =TEXT(A1,"""0001""00000") --ron |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what function to use
On Thu, 29 Jan 2009 08:12:02 -0800, Frank Situmorang
wrote: Hello, This is my row that I want to convert from number to text but with certain criteria: A 1 2 . . . 12 to text to show it as follows 000100001 000100002 when number is 2 digits it should show 000100012 000100300 my number run upto 600 Please help us wahat function fo excel should we use, th forth character sould always show 0001 Thanks in advance Actually, this works just as well, and is simpler: =TEXT(A1,"000100000") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
![Frank Situmorang[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
