Every so-often, when I am working in a fairly basic spreadsheet (just dates and text) when I change the text formatting for an entire row, or even just the first 4 cells, the data and formatting information in the third cell on that row is overwritten with a 5-digit number. The bug is reproducible (if I undo changes and repeat the process) and has happened now on quite a few different sheets (of the same type, but built from scratch each time.) Also, if memory serves (which it may well not) it is the same number each and every time that is corrupting my sheet.
I was hoping to find some kind of update to the firmware on my device.
An expert who has achieved level 3 by getting 1000 points
All-Star:
An expert that got 10 achievements.
MVP:
An expert that got 5 achievements.
Master:
An expert who has achieved Level 3.
Master
903 Answers
Re:
In my opinion it will be interesting to find out if this is one general bug and if there is any statement from Microsoft. If there is a general bug it should be present on other PDA units. Have you any possibility to check it on some another PDA (another producer)?
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Right-click the cells and go to 'Format Cells'. Then, select the correct format. If you're wanting to leave the slash (/) in the number, you'll probably have to make it a text format.
the problem text itself highlights that you are not uploading the compatibility file with respect to your application version settings. don't worry and have fine
Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).
1) Make sure each column in your spreadsheet has a heading.
2) Highlight (select) the column of birthdays.
3) Choose Format from the menu bar.
4) Choose Cells... from the drop-down menu.
5) For the "category", choose Custom.
6) In the "type" box, type yyyy
7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.
8) Now, highlight the entire table
9) Then, choose Data from the menu bar
10) Choose Subtotals... from the drop-down menu
11) In the "At each change in" box, choose the name of the column with the birth dates
12) In the "Use function" box, choose Count
13) Leave all other choices at their defaults
14) Click OK, and you are done.
Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.
Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.
×