Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


migration rejected from Jul 6 '15 at 16:29

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by fixer1234, mdpc, Scott, DavidPostill, Steven Jul 6 '15 at 16:29

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

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