Default Number Format in Excel 2010 worksheet randomly changed to a Date Format

[doreanna]

I have been working in a worksheet with 10 tabs, and suddenly all of my numbers turned to long date format. I manually changed them all back to what they were. General, Currency, %, etc. but the default seems to be stuck in the long date format. When I create a new tab it is automatically all long dates. Very strange.
Oh, and the other weird thing is when I send it to other people, some people see the correct formats and when other's open it the numbers all go back to the long date format. VERY Frustrating.
Would love to get some advice.

 

[dida]

I have the same problem, specific file got date cell format by default any new cell in the file and any new sheet and I just can find a way to change it but changing it manually<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Anyone have solution?? <o></o>

 

[Sektor]

If you select Date format with start sign (*), then it's locale-specific, i.e. format is stored in Windows settings.

 

[dida]

I understand, but this is not the issue. In another file all the cell got format of EURO currency and again I have to change it manually, new sheet get his entire cell format as Euro currency,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I think it is excel 2010 bug or some unexplained development,<o></o>
It has nothing to do with the controllable panel definition since 2 specific file got default cell format, while the others are OK<o></o>
I will really appreciate answer it is driving me crazy...<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape id=Picture_x0020_1 style="VISIBILITY: visible; WIDTH: 12pt; HEIGHT: 12pt; mso-wrap-style: square" alt="Description: 0" type="#_x0000_t75" o:spid="_x0000_i1025"><v:imagedata o:title="0" src="file:///C:\DOCUME~1\diklai\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.gif"></v:imagedata></v:shape><o</o>

 

[Sektor]

Set Custom format: "€"0

 

[fella5]

I'm also running into this issue too on Office 2010.

 

[eagle15]

I am running into the same exact problem. I randomly get formats changed to Euros, date formats change randomly as well. It this a bug in Excel 2007?

 

[lelele]

I have the exact same problem and would love to hear of any fixes.

 

[thx1200]

Me too. This is such a waste of time for me to have to go back and reformat columns just because Excel decides everything is now a date instead of a number! Is there any workaround at all for this?

 

[RoryA]

seems to be a sporadic bug - if you alter the 'Normal' cell style to use General number format again it should fix it.