Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=Text
I have a long column of ref numbers, each cell needs to be converted
to text. So i am using =TEXT (B2,0) - (with the result I then copy and paste as special) This works fine .... up to a point. As I also need the ref number to have 8 digits so a number that starts as 6 digits needs to be padded with two zeros at the start ie 585859 needs to end up as 00585859. Can this adjustment be made in the original =TEXT statement, if so how or what is the best way to deal with this problem. With thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=Text
On Mon, 6 Jul 2009 07:23:25 -0700 (PDT), Bob
wrote: I have a long column of ref numbers, each cell needs to be converted to text. So i am using =TEXT (B2,0) - (with the result I then copy and paste as special) This works fine .... up to a point. As I also need the ref number to have 8 digits so a number that starts as 6 digits needs to be padded with two zeros at the start ie 585859 needs to end up as 00585859. Can this adjustment be made in the original =TEXT statement, if so how or what is the best way to deal with this problem. With thanks Try this: =TEXT(B2,"00000000") Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=Text
Try: =TEXT (B2,Rept(0,8)) -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112942 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=Text
On 6 July, 15:29, NBVC wrote:
Try: =TEXT (B2,Rept(0,8)) -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile:http://www.thecodecage.com/forumz/member.php?userid=74 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=112942 Thanks NBVC exactly waht I was after. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) |