How do I stop rounding numbers?

I know the number stored in Excel is not rounded but the displayed number is.
I am looking for a solution to display numbers as entered. It is an
accounting form I am developing and displaying rounded numbers in the
spreadsheet is confusing to the user. Please help. Thanks Jack

Hi

would increasing the number of decimal places visible to the user solve your
problem?

Cheers
JulieD



"Jfeeman" <Jfeeman@discussions.microsoft.com> wrote in message
news:D603409D-96B5-4FD1-9970-5496F7D70324@microsoft.com...
>I know the number stored in Excel is not rounded but the displayed number
>is.
> I am looking for a solution to display numbers as entered. It is an
> accounting form I am developing and displaying rounded numbers in the
> spreadsheet is confusing to the user. Please help. Thanks Jack

You could use a custom format of #,##0.0######

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jfeeman" <Jfeeman@discussions.microsoft.com> wrote in message
news:D603409D-96B5-4FD1-9970-5496F7D70324@microsoft.com...
> I know the number stored in Excel is not rounded but the displayed number
is.
> I am looking for a solution to display numbers as entered. It is an
> accounting form I am developing and displaying rounded numbers in the
> spreadsheet is confusing to the user. Please help. Thanks Jack

Thanks Julie and Bob!
It seems that the problem is when entering very small numbers (i.e., 0.0003)
the display rounds down to 0.0000 which indicates to a user that nothing was
entered. As this form will be printed and given to a customer all zeroes in
the printed copy would convey the wrong message.
I will try the custom format you suggested and see if it works for them.
Thanks both of you for your help.

"Bob Phillips" wrote:

> You could use a custom format of #,##0.0######
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jfeeman" <Jfeeman@discussions.microsoft.com> wrote in message
> news:D603409D-96B5-4FD1-9970-5496F7D70324@microsoft.com...
> > I know the number stored in Excel is not rounded but the displayed number
> is.
> > I am looking for a solution to display numbers as entered. It is an
> > accounting form I am developing and displaying rounded numbers in the
> > spreadsheet is confusing to the user. Please help. Thanks Jack
>
>
>