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 worksheet with thousands of number cells, all formatted "Number, 3 decimal places, use 1000 Separator ( )".

Starting a few days ago, if I edit a formula in any of these cells to reference another cell, Excel will change the decimal places to 14.

For example, "=C$53^$B$4" => "=C$53^$B$10" will cause this.

I am not aware of any settings being changed.

Any ideas why this is happening and how to fix this?


This does not happen on all cells. I cannot see a difference between the ones it does and doesn't occur on.

share|improve this question
Do you have any conditional formatting in the worksheet or macros in the workbook? Do you mean Separator() or Separator(,)? Does the format switch to scientific notation on changing the formulae? – pnuts Dec 2 '12 at 12:55
I do have macros. The format remains as numeric. I mean Separator( ) because I'm not in the US and we use a space in place of a comma. – IamIC Dec 10 '12 at 11:51
Advice for that here is to turn of any memory optimiser. – pnuts Dec 10 '12 at 16:43
A bit ominous this question seems to do with a very similar problem. – pnuts Dec 11 '12 at 18:11
This may be of interest though:…. – pnuts Dec 11 '12 at 18:17

You must log in to answer this question.

Browse other questions tagged .