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 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?

EDIT

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. –  IanC Dec 10 '12 at 11:51
1  
Advice for that here is to turn of any memory optimiser. –  pnuts Dec 10 '12 at 16:43
1  
A bit ominous this question seems to do with a very similar problem. –  pnuts Dec 11 '12 at 18:11
1  
This may be of interest though: answers.microsoft.com/en-us/office/forum/office_2010-excel/…. –  pnuts Dec 11 '12 at 18:17

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.