Excel Function????

[nathanielcohen]

Hi,
I'm gonna explain you waht I want with a sample:
I have a column A with those values:

1.2
15.8
854.6
12.98
1548.96
124.89
1258.2
1.2
58.3
546.8
...

My lenght value are never standard, so I want to know which formula
can use to get this kind of result (lenght = 8 with 2 decimal)

00000001.20
00000015.80
00000854.60
00000012.98
00001548.96
00000124.89
00001258.20
00000001.20
00000058.30
00000546.80
...

Thank you for your help

 

[NH]

go to format--Cells--custome format and type eight zerosd/deimal/two zeros
as such 00000000.00

 

[JulieD]

Hi

you can use a custom format to change the way the numbers look (without
actually changing the numbers), select your numbers, choose format / cells,
click on the number tab, choose custom on the left hand side and in the type
line on the right hand side type
00000000.00
click the OK button.

if you want to change the values & not just the formatting of them and they
don't actually need to be numbers you can in the column next to your numbers
type
=text(A1,"00000000.00")
and copy down, you can then copy this column, choose edit / paste special -
values and then delete the original column.

Hope this helps
Cheers
JulieD

 

[nathanielcohen]

Thanks you so much It was so eas

 

[JulieD]

glad to assist