ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Why am I getting ### when I enter an accting number and hit enter (https://www.excelbanter.com/new-users-excel/213768-why-am-i-getting-when-i-enter-accting-number-hit-enter.html)

CC Mac

Why am I getting ### when I enter an accting number and hit enter
 
In the Excel program:
I type a number in the number mode or the accounting mode, and when I hit
enter, it becomes #####!

Luke M

Why am I getting ### when I enter an accting number and hit enter
 
Either your column is not wide enough (make it wider?) or you entered an
invalid number, such as multiple decimals, negative date, etc.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CC Mac" wrote:

In the Excel program:
I type a number in the number mode or the accounting mode, and when I hit
enter, it becomes #####!



All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com