+ Reply to Thread
Results 1 to 2 of 2

Cells changing to date

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Cells changing to date

    Have worked with a sheet for several years. I just copy the sheet and use eg. 2011 and use most of the cell values I have before entered.
    This time I did the same for 2011 and cells have changed the input , to . And many cells just have the ###### . I have adjusted the size but the cell have changed to a date cell instead of standard and text cell.
    When I mark the row or a few cells just to change the comma to point the value I have entered before is gone and instead the date is shown as a number. This frustrate me a lot as I need to manually enter previous value first by changeing the cell to a text cell and then the old value.
    If I had just one or two hundred cells with this it would be ok. But my different sheets contain thousands of cells with different values.
    What could be wrong and what to do?

    Appreciate any suggestions I can try


  2. #2
    Valued Forum Contributor
    Join Date
    Melbourne, Australia
    MS-Off Ver
    Office 2016

    Re: Cells changing to date

    What method did you use to create the copy worksheet? I find the most effective way is to right click on the tab of the worksheet I want to copy then select the <Move or Copy> option. All existing formatting, including column widths, is replicated as well as data and formulas.
    Trish in Oz
    A problem well defined is a puzzle half solved

    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1