|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com