Numbers displayed in date format
Hello
Have a really annoying problem I have been trying to solve for a long time: Lots of numbers are displayed in date formats on opening a workbook. This happens regardless of them being fixed values or resultant values of formulas. Seems to be totally random which cells it affects. Reformatting does not help - samen story the next time I open the workbook. Time-consuming - annoying - cryptic to other users.
Please upload a sample workbook displaying the problem.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
(How make an accident happen when you want it to...?)
Well, I doubt we'll be able to help without seeing the problem ... What you describe is not normal behaviour, after all.
Sure - I'll be back
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks