Excel Malfunction

anshikam

Board Regular
Joined
Aug 20, 2016
Messages
81
Hello,

This may sound weird but I have a worksheet where the formulas in a few rows don't work while they work in others....no difference and no reason for this to happen.
In the past I have had to delete rows and read ........is there anyone who can shed light on this and fixes.....

One thing that has happened is my date format suddenly changed from dd-mm-yyyy to mm-dd-yyyy. I formatted it back but in the cell value bar at teh top it still shows mm-dd-yyyy.

The error is only happening in cells which show format as mm-dd-yyyy......which i see there are few ......
Not sure how this changed in the first place and why only a few cells changed and not all 2500 cells.
 
Last edited:

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,160
Office Version
  1. 2010
Probably text looking like dates instead of real dates? ( if left aligned without manual alignment = text)
Formatting is only what XL shows you, not the underlying value
If there are only few, format as General and enter the dates manually ?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,428
Members
412,529
Latest member
cTatch
Top