Pranav,

That works great!

I modified it to ######.###### because I don't want any trailing zero's.

One more question do you know how to get rid of the Decimal when a whole
number is the answer?

Example

Current answer = 345.
Desired answer = 345

The difference above is the decimal that appears in the current answer.

Ben

"Pranav Vaidya" wrote:

select the cells you want to format
go to cell properties
on the number tab select 'Custom'
Type this as your custom format 0.00#####

This will always display minimum 2 decimal places and for other numbers
actual decimal places.

Hope this helps!!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Ben Dummar" wrote:

How do you set the workbook to expand the cells to the last digit after the
decimal point but not display any trailing zero's?

Example how would you display A1=3.15476 & A2=4.2 instead of A1=3.15476 &
A2=4.20000 without setting the format individually for every cell, and
without any rounding involved?

Thanks,

ben