Have Excel display an error rather than rounding # to fit column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank - 25 Jul 2006 18:04 GMT

Excel can be misleading when it helpfully rounds your numbers to fit the
existing column width. In most instances I would prefer that, for example,
the "##########" indicative of insufficient column width be displayed, rather
than an erroneous (rounded) number.

Reply to this Message

Dave Peterson - 25 Jul 2006 18:35 GMT

Maybe you could give the cell a Number format (as many decimal places as you
need).

(Number--not General under format|cells|number tab)

> Excel can be misleading when it helpfully rounds your numbers to fit the
> existing column width. In most instances I would prefer that, for example,
[quoted text clipped - 9 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=cc1dc1b9-e2ad-4
e80-9833-eaf8f1d71773&dg=microsoft.public.excel.setup

Signature

Dave Peterson

Reply to this Message