How do I stop rounding numbers?

J

Jfeeman

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
 
J

JulieD

Hi

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

Cheers
JulieD
 
B

Bob Phillips

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

--

HTH

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

Jack_Feeman

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.
 
Top