ExcelBanter - With Autosum, hash (#) symbols appearin cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - With Autosum, hash (#) symbols appearin cell (https://www.excelbanter.com/excel-discussion-misc-queries/102853-autosum-hash-symbols-appearin-cell.html)

Stephen Norman

With Autosum, hash (#) symbols appearin cell

At times, when I use the Autosum function, the target cell displays only hash
symbols. The column has been formatted to currency.

DavidObeid

With Autosum, hash (#) symbols appearin cell

Could it be that your column is just too narrow? Try increasing the
column width (Format, Column, Width).

--
DavidObeid

------------------------------------------------------------------------
DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238
View this thread: http://www.excelforum.com/showthread...hreadid=567738

All times are GMT +1. The time now is 04:31 AM.