| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why do I get this ###### instead of 11:00 p.m. in formatted cell?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Why do I get this ###### instead of 11:00 p.m. in formatted cell?
One reason could be that the column isn't wide enough. Try widening the
column. -- Biff Microsoft Excel MVP |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Why do I get this ###### instead of 11:00 p.m. in formatted cell?
Always supply your formula and the values of the input cells
-- Kind regards, Niek Otten Microsoft MVP - Excel "new user" <new wrote in message ... | |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Why do I get this ###### instead of 11:00 p.m. in formatted cell?
On 15 ρεο, 19:43, new user <new wrote:
Not to forget: if cell contains fomula that evaluates time value and result turns to be negative, it will be shown as ###### no matter how wide column is. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find out how a cell is formatted | Excel Discussion (Misc queries) | |||
| Formatted Cell | Excel Discussion (Misc queries) | |||
| Calculate from time formatted cell | Excel Worksheet Functions | |||
| number formatted cell | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Linear Mode
