G
Guest
I have had two repeating problems where fromats have been
changed 'automatically' and unexpectedly.
a) Copy pasting from an Access query into a spreadsheet
(paste using "paste special/text" - never caused a problem
in past 2 years). 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) A completely separarte but possibly related problem
occured a day earlier 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 (some of the data appeared to be
corrupted)
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. Also tested on a second
machine on the network with the same files/actions and
again got this problem.
changed 'automatically' and unexpectedly.
a) Copy pasting from an Access query into a spreadsheet
(paste using "paste special/text" - never caused a problem
in past 2 years). 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) A completely separarte but possibly related problem
occured a day earlier 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 (some of the data appeared to be
corrupted)
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. Also tested on a second
machine on the network with the same files/actions and
again got this problem.