I formatted a column of phone numbers Format/Cell/Number/Text.
But when I then edited some of the numbers Excel changed them to dates.
In the description of “Text” it says “The cell is displayed exactly as entered” Obviously this is not so.
What is going on?
Here is the task I am working on. I have a large number of phone numbers in a db. 99% start with “64”. Since all the users understand that I am trying to save width I am trying to delete all the “64”s with the replace command.