spontaneous change of formatting

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hello,

In the company where I work we are currently experiencing a strange
problem.
What happens is that randomly and spontaneously, the formatting of the
spreadsheets we use gets changed. Say numbers formatted like dates and
vice versa for example.

This has never happened in the past, and it is something occurring
over the last month or so.

The spreadsheets have macros however, I checked the code in depth and
there is no formatting at all; that is the formatting is just part of
the cells properties and that gets changed.

We are using Office 2007 and all the files are in .xlsm format.

Have you got anything to suggest for this? Has anyone experienced the
same problem?

The only thing I can guess is that it is related to a Microsoft
Update, but of course I cannot prove it.

Thanks a lot for your time,

Mark
 
As ALWAYS, post your code for comments. You may need to add a line
cell(i,9).numberformat="yymmdd"
 
As ALWAYS, post your code for comments. You may need to add a line
cell(i,9).numberformat="yymmdd"

Don,

Read the post again, because it is clear that you did not.

Thanks,

Mark
 
A very good way to win friends.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
As ALWAYS, post your code for comments. You may need to add a line
cell(i,9).numberformat="yymmdd"

Don,

Read the post again, because it is clear that you did not.

Thanks,

Mark
 
A very good way to win friends.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software




Don,

Read the post again, because it is clear that you did not.

Thanks,

Mark


Dear All,

I found more references to the problem I am experiencing. It looks
like it is a known issue:

http://www.pcreview.co.uk/forums/thread-3620548.php

As I stated before, that is NOT related to coding at all but rather an
auto format function of Excel.

Does anyone know how to turn this feature off?

I am not asking for a:

..numberformat="yymmdd"

solution, because that would be impractical but rater as a way to
force an Excel workbook to leave the data as they are rather than
trying to be clever guessing the formats.

Thanks,

Mark
 
Back
Top