nunber format in Excel 2000
 

I am looking for a way by using the "format cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle

try
#,###0.000000

--
Don Guillett
SalesAid Software

"Erle" wrote in message
om...
I am looking for a way by using the "format cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle

####"000"

will give you 3 trailing zeros.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am looking for a way by using the "format
cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's
and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle
.

Unlike leading zeros yopu can't format for trailing zeros,
if all trhat you want is to get a certain number of zeros
after the numbers you type you can temporarily change
fixed decimal places under toolsoptionsedit and if you want
6 zeros change it to -6, now if you type 123 it will retrun

123000000

Don't forget to turn of the fixed decimal place when you are done

only other way I know of is using an event macro


Regards,

Peo Sjoblom


"Erle" wrote:

I am looking for a way by using the "format cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle