| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a number a number in column
Try this if you want to insert "0":
=TEXT("0"&H2,REPT(0,LEN(H2)+1)) and this, if you want to insert "1": =TEXT("0"&H2,REPT(0,LEN(H2)+1)) Regards, Stefi €˛webfort€¯ ezt Ć*rta: hi, thanks for the reply, it keeps saying you have entered to too few arguments for this function? Thanks -- webfort ------------------------------------------------------------------------ webfort's Profile: http://www.excelforum.com/member.php...fo&userid=7964 View this thread: http://www.excelforum.com/showthread...hreadid=543232 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Insert a number a number in column | Excel Programming | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Hybrid Mode
