Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 #####! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 #####! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions |