• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell choose a different number format when file is opened

T

TonyP

New Member
I'm new to the forum but I'm a frequent visitor to Chandoo. Thank you for all the insight.

I have an issue that have not been able to resolve, and it's annoying. I format the way I want the number cells to be formatted and then close the file. Sometimes, and only sometimes, when I re-open the file, ALL the number cells will be reformatted to date fields or to some other number format that I would never have chosen. For example if a column has Currency formatting with $, it may come back with Yen or RMB or Pound or anything at all. To correct this I reformat them. and everything is good until I close the file and re-open it. The same file will do the same if I send it to someone. So it's not a computer dependent thing. and it happens rarely. But when it does it's so time consuming to put it all back to "normal"; only to have it reset to weird formats next time I open it.

Is this an Excel bug? What causes it?
TonyP
 
Hi Tony

2 quick questions:

  1. What is the source/origin of the data? (esp. wwant to know if your data is a query table)
  2. Does your workbook contain any event procedures (such as workbook before close, workbook open procedures - please also check sheet event procedures)?
Regards
Jon
 
Hi Tony ,

To add to what Jon has posted , does your file have only one worksheet tab ? If it does , can you try with another tab to see whether the problem is the same ? If it does have multiple tabs , is the problem on all the sheets or is it restricted to just one or even a few ?

Narayan
 
You must log in or register to reply here.
Back
Top