unwanted formatting changes

[glenn mckinlay]

I have had two repeating problems where fromats have been
changed 'automatically' and unexpectedly.

a) Copy pasting from an Access query into a spreadsheet. I
preset certain column formats to text but on pasting one
column changed to currency format and another to data
format (the data I am pasting in is text format in Access).

b) On making a copy of a sheet inside a workbook data
formats changed in a number of other sheets and the new
sheet being created.

I was able to repeat both problems with the same actions.
Something appears to be wrong with Excel. I reinstalled
today but got a repeat of A above.

 

[BrianB]

Might be one of those things that is "a feature not a bug" (grin) - bu
still difficult to figure out exactly what is happening.

It seems you are using data from MS Access (?).

Using Access/Excel 97. Exporting from Access to an existing Excel shee
does *not* change my pretty formats.
Importing data from Access using Excel does re-format my Exce
worksheet cells

 

[Guest]

I think this is a bug

I am running the query in Access then copy/ paste
special /text to get the data into Excel.
I have used this many many times in the paste but only now
have a problem.

The fact that I had another "unwanted automatic format
change suggests that something more odd is occuring