Number processing

  • Thread starter Thread starter Alan Dresch
  • Start date Start date
A

Alan Dresch

Help please

I have columns of numbers with a maximum of 6 digits in
each number - Example -25.64.

Some numbers only have (most extreme case)one digit -
Example 5.

Currently I am manually 'processing' all numbers to have 6
digits by adding + and 0's in the relavent places.

How can I automate this labourious manual task?

For Information

I CONCATENATE three columns of these 'processed'numbers as
TEXT for use later on in a VALIDATE drop down list. From
this list I re-separate the numbers to specific cells with
use of MID, LEFT etc.

Thanks for your advise.

Alan Dresch
 
Hi alan
can you post some example data / the formula you use for concatenation
In general I would try something like
=TEXT(A1,"00") & TEXT(B1,"00") & TEXT(C1,"00")

or format the resulting cell with the custom format "000000"
 
Back
Top