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

General?
--
David Biddulph

"Ben Dummar" <(E-Mail Removed)> wrote in message
news6F70643-EF0D-4051-9D34-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news6F70643-EF0D-4051-9D34-(E-Mail Removed)...
> > 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
>
>
>

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

"Pranav Vaidya" <(E-Mail Removed)> wrote in message
news:5C2B2F1A-AA78-4A15-84B8-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news6F70643-EF0D-4051-9D34-(E-Mail Removed)...
>> > 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

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