Auto Formatting Decimal Point

[Guest]

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

 

[Guest]

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!!!

 

[David Biddulph]

General?

 

[Guest]

I think changing to general will not change the existing data whereas will
affect the new entries only.

 

[David Biddulph]

Which version of Excel behaves that way, Pranav? 2003 doesn't.

 

[Guest]

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