Text Length

[Soniya]

Hi All,

How can I fix the lenght of a cell using code/

i have numbers formated as text im my column A which os
copied to another sheet and i want to fix the length to 7.

for eg if the number is 1 it should look like 0000001 and
if it is 12345 then 0012345

TIA
Soniya

 

[Kalle]

just format the cells userdefined
format is 0000000

 

[Frank Kabel]

Hi
I would format the column A as number (not as Text) and use a custom
format for displaying the values. e.g. the custom format
0000000
(entered in 'Format - Cells')

If you need a text value you may use the formula
=TEXT(A1,"0000000")

 

[Chip Pearson]

Soniya,

Use a custom number format. Select the cells that will contain
the values, then go to the Format menu and choose Cells. In that
dialog, choose the Number tab and in the Category list box,
choose Custom. In the format box, enter 0000000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Kalle]

what does this mean?

 

[Frank Kabel]

TIA: thanks in advance

 

[Tom Ogilvy]

for each cell in selection
Cell.Value = Right("'0000000" & cell.Text,7)
Next