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

Postby Um9iaW4gRA » Sat, 17 Jul 2004 19:01:02 GMT

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

Postby Frank Kabel » Sat, 17 Jul 2004 19:15:29 GMT

Hi
see your other post

P.S.: please don't multipost :-)

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

RE: Standardisation of number length

Postby Um9iaW4gRA » Sat, 17 Jul 2004 19:17:01 GMT

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







Re: Standardisation of number length

Postby Norman Harker » Sat, 17 Jul 2004 19:17:51 GMT

Hi Robin D

Format > Cells > Custom

Type in

00000000
OK


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



Similar Threads:

1.\tableofcontent misaligns the page numbers if section title has critical length

2.\tableofcontent misaligns the page numbers if section title has critical length

3.Excel number length-max length.

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.

4.Need to fix the number filed so all numbers are 8 in length

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?

5.number length with a id number only

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

6. Fitting lengths into a longer length

7. Validation length, Range length

8. how to get the width or length byExifR how to get the width or length byExifReader丂



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 4 guest