ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   My numbers turn into # signs, when I move to the next block (https://www.excelbanter.com/excel-worksheet-functions/239563-my-numbers-turn-into-signs-when-i-move-next-block.html)

Gogetter72

My numbers turn into # signs, when I move to the next block
 
I am having trouble with inputing dates within the cells. When I move to the
next block, the numbers turn into # signs. What do I need to do to fix this
problem?

David Biddulph[_2_]

My numbers turn into # signs, when I move to the next block
 
Make your column wider, or your font smaller, or choose a date format that
is shorter (such as dd/mm/yy instead of dd/mm/yyyy or dddd dd mmmm yyyy).
--
David Biddulph

"Gogetter72" wrote in message
...
I am having trouble with inputing dates within the cells. When I move to
the
next block, the numbers turn into # signs. What do I need to do to fix
this
problem?





All times are GMT +1. The time now is 04:03 PM.

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