Auto Formatting Decimal Point
 

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

Auto Formatting Decimal Point
 

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

Auto Formatting Decimal Point
 

General?
--
David Biddulph

"Ben Dummar" wrote in message
...
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

Auto Formatting Decimal Point
 

I think changing to general will not change the existing data whereas will
affect the new entries only.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"David Biddulph" wrote:

General?
--
David Biddulph

"Ben Dummar" wrote in message
...
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

Auto Formatting Decimal Point
 

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

"Pranav Vaidya" wrote in message
...
I think changing to general will not change the existing data whereas will
affect the new entries only.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!

"David Biddulph" wrote:

General?
--
David Biddulph

"Ben Dummar" wrote in message
...
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

Auto Formatting Decimal Point
 

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