WORKBOOK Defaults changed

jaketsuar

New Member
Joined
Apr 9, 2011
Messages
2
I have a workbook which I have used for tracking money for months.

Now, all the sudden, when I put a dollar value in a cell or create a new worksheet and put dollar values in cells it defaults to dates.

What did I change to make this happen?

Thanks.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

baodinh

New Member
Joined
Feb 27, 2011
Messages
36
Does this happen when you format the value as dollars?

No idea why you're experiencing these symptoms. Post an example of the spreadsheet if you still have issues.
 

jaketsuar

New Member
Joined
Apr 9, 2011
Messages
2
On the link you provided from Microsoft, the second answer, method 2 worked for me (Click cell styles, then normal item at top left, then right click normal and hit modify, then click format button, then change number to general).
Thanks, much frustration now gone!
Would be nice to know WHY it changed.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top