Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a spreadsheet which has data linked in from other tabs on the same spreadsheet. Each of the source tabs has a column formatted as a number with no decimal. The tab they're linked to has the same exact column formatting. However, the formatting keeps reverting back to a date format. Why won't this keep the formatting I originally specified for the entire column?

share|improve this question

migrated from stackoverflow.com Jun 3 '11 at 12:47

This question came from our site for professional and enthusiast programmers.

    
What do you mean by "reverting back"? When does it do such? If you change the value? Copy the cell? Edit a formula? –  Howard Jun 3 '11 at 5:15
    
I will enter data into one of my tabs. That cell is linked to my "roll-up" tab. The cells in both tabs are formatted as a number. The data looks good. I save the file. Then, I'll update a row several lines down in that same tab. When it links to the "roll-up" tab, it is now showing as a date. I've had this happen on another file that has no linked data. I change an entire column to be formatted as a date (formatted like 3/14/11). It seems that every once in a while... when I'm entering a date, the format will spontaneously change to show a format like 3/14/2011. –  Sarah Jun 3 '11 at 5:49
    
Which version of Excel are you using? On what operating system? What are your language / locale setting? In particular, which symbol is used for decimal point, thousands separator, date separator? –  Jonas Heidelberg Jun 3 '11 at 11:50
    
in the "roll-up" is where the format is not being maintained correct? or both? When you check the format properties of the offending cells what type format do they show? we know there are no macros at work? –  datatoo Jun 4 '11 at 16:39
    
by "linked in from other tabs" do you mean using a reference such as =Sheet2!D6 or using a VLookup() or similar function, or...? –  StevenV Aug 4 '11 at 14:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.