Auto Formatting Decimal Point

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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!!!
 
I think changing to general will not change the existing data whereas will
affect the new entries only.
 
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
 
Back
Top