Display decimals without condensing or trailing zeros

[#1]

Without formatting, numbers are condensing after 5 decimal places.

Now I can format this to show all the numbers formatted to 10 decimal places, but I don't want the trailing zeros.

Is it possible to do this with only formatting functions? I'd rather not use string functions to remove the excess zeros.

=ValueLoop(1,10)	Desired Result
1	0.1
2	0.01
3	0.001
4	0.0001
5	0.00001
6	0.000001
7	0.0000001
8	0.00000001
9	0.000000001
10	0.0000000001

Thanks.

[prat1507]

=Num(0.00200, '##')

[#3]

Is this not the same as applying no formatting? I'm still getting e notation after 5 decimal places.

[prat1507]

Apply Num(X,'##')

where X is expression used by you above as Num(1/pow(10,ValueLoop......,'#.#########')

[prat1507]

Use

=Num(0.00200, '(dec)')

[#6]

This seems like it technically should work, but it seems to be manipulating the actual results somehow.

[prat1507]

Use this

=Num(1/pow(10,ValueLoop(1,10)),'#.'&Repeat('#',ValueLoop(1,10)))

[#8]

Thanks Pratyush, but I need a way to format the decimals in general, not just for this valueloop example.

[#9]

Unfortunately, I think I'm going to have to use string functions to remove the trailing zeros.

This is the best I could come up with:

Replace(RTrim(Replace(Num(1/pow(10, ValueLoop(1,10)),'#.##########'),'0',' ')),' ','0')

[sunny_talwar]

Try this may be

=Num(Num(1/pow(10, ValueLoop(1, 10)), '##.##############'), '##.' & Repeat('#', FindOneOf(Mid(Num(1/pow(10, ValueLoop(1, 10)), '##.##############'), Index(Num(1/pow(10, ValueLoop(1, 10)), '##.##############'), '.')), '123456789', -1)-1))