Auto Formatting Decimal Point

B

Ben Dummar

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
 
P

Pranav Vaidya

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

Pranav Vaidya

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

Ben Dummar

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
 
Top