Computer hardware and software
dates in excel change to number signs?
Question : dates in excel change to number signs?
i’m doing my timesheet for work and the template is through excel. Its the same hours every week, so i always just open it up and change only the dates. Anyway, the first 11 of the 14 days work fine, but then when i get to the final 3 days of the pay period the dates automatically change to number signs. (#). The weird thing is that its a problem only with those 3 dates it seems, not even the cells themselves. B/c lets say one of the dates that change to number signs is 5/24/10, if i input 5/7/10 just out of curiosity, it doesnt change to number signs. Anyone know how i can get it to stay as the date?
timesheet template
Best answer:
Answer by Erik
when something like a date doesn’t fit in the size of the cell, it shows a ####. Just make the cell wide so all of the dates fit. Chances are, those dates that do that are just longer than the other ones.
-
-
#2 written by Scooter 1 year ago
I too utilize excel for this same purpose, and it does all the math for me :-) Your problem is with the cell format — not that you have too many characters…
To reformat the cell, chose the applicable cell (left click once) then right click in that cell. A drop-down menu will appear which has three (3) sections.
The first option in the lower-most section is “Format cells…” Click on that option and another menu opens in which you can format six (6) parameters of the worksheet cells. The first tab is “Number”, and that is where you can chose the numeric format of the cell structure. By default it is set to “General”, so you may wish to set it to “Number”? (Note that you can also set the decimal places.)Hope this helps?
~Scott
- Comment Feed for this Post
Either your Cell Width is too narrow, or (if the date is from a formula) you have a negative date/time in that cell.
Example:
The following formula will result in #######:
=TODAY() -1 -TODAY()