I need to format numeric - decimal 9.0 size 15 i.e. 1.50 = 000000001500000 Thanks.
P pm May 24, 2007 #1 I need to format numeric - decimal 9.0 size 15 i.e. 1.50 = 000000001500000 Thanks.
T Toppers May 24, 2007 #2 Given your example, this will display the number as TEXT =TEXT(A1*10^6,"000000000000000") If you want it numeric, multiple by 10^6 (10 to power 6) and Format=>custom=>000000000000000 HTH
Given your example, this will display the number as TEXT =TEXT(A1*10^6,"000000000000000") If you want it numeric, multiple by 10^6 (10 to power 6) and Format=>custom=>000000000000000 HTH
