## Standardisation of number length

MS EXCEL

### Next

• 1. Missing information in excell
When selecting multiple columns or rows, IE click on column A, hold and drag multiple columns, the little box that counts the number of columns, IE 1C, 2C, 3C..., is not there. So when I do a V-Lookup function, and scroll across the columns I need to use, it doesn't count them for me. Has anyone else seen or have had this problem? TIA Stretch
• 2. formula with increments of 6
i am creating an work order with pricing. the overall size breaks down into many parts of different sizes. i use square footage and linear measurments. right now i've got all the pricing formulas figured out for each part (for the exact sizes used), but i need the overall size to be rounded up to increments of 6. for example the overall size is 58" x 32" part #5: size is 26 1/2" x 30 1/4" (calculated in sq ft) cost of part #5 is 4.5/sqft so the formula i'm using is =(26.5*30.25/144)*4.5 but i need the the overall size to be rounded up to the next 6" increment in order for each part to be PRICED correct - but CAN'T change the sizes on my work order so part#5 needs to be priced as if the overall size is 60 x 36 (the part size would then be 27 1/2" x 34 1/4" help please :(
• 3. Oversettelse av Engelsk formel
Har f氓tt hjelp med mitt problem, men den formelen jeg fikk er p氓 engelsk og kan ikke skrives slik i en Norsk Excel =AVERAGE(LARGE(MOD(COLUMN(A1:M1),2)*A1:M1,ROW(INDIRECT("1:5")))) Kan noen hjelpe med 氓 oversette den?

### Standardisation of number length

```I have a long list of numbers which I need to convert to a standard length of 8 characters. For example:

5 to 00000005
18 to 00000018
1471 to 00001471

Is there a quick way of doing this rather than manually editing each cell?
--
Many thanks
Robin

```

### Standardisation of number length

```Hi

a standard length of 8 characters. For example:
editing each cell?
```

### RE: Standardisation of number length

```Please ignore - posted twice in error.
--
Many thanks
Robin

```

### Re: Standardisation of number length

```Hi Robin D

Format > Cells > Custom

Type in

00000000
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
XXXX@XXXXX.COM

```

```If I have a number more than 16 digits in a cell in excel and then when
brought to VB through ADO, I get some different weird value. Does any one of
you know the reason? And can give some links to msdn or somewhere where the
max size is formally specified.
Thanks,
Sachin.

```

```not all the numbers are the same.

it must be 8 numerical fields but some numbers are
well let me show you an example.

01234567
12345678
123
47864
3456763

They need to fixed up to look like:

01234567
12345678
00000123
00047864
03456763

How do I get excell 2003 to do this for me?  Or does it need to be a script
of some sort?

```

```Hello everyone,
I've been working on a project and I can't seem to get the formula or
worksheet change correct..  In cell D3 (which is where the employee will
enter his/her ID #), I need to limit the number length to 8 digits no less no
more and it must be only numbers, no letters or characters and it needs to
allow a zero in the front or the 8 digits.  Can someone help me with this
problem?  I'm learning visual basic but I am still very 'green' and confused
with the format needed.

thank you
rob
```