P
Peter
I have come across the following situation:
When running a query in Access XP and then copying the
results across to Excel, the numbers do not get
automatically recognized by Excel, but come with the 'note'
on the top left corner of the individual cell, allowing
users to convert the content to a number. Also if there are
blanks between the cells, users can't just highlight all
cells and convert to numbers.
What is a simple why to get the content converted to a
number? Is there a setting to switch off this behaviour?
When running a query in Access XP and then copying the
results across to Excel, the numbers do not get
automatically recognized by Excel, but come with the 'note'
on the top left corner of the individual cell, allowing
users to convert the content to a number. Also if there are
blanks between the cells, users can't just highlight all
cells and convert to numbers.
What is a simple why to get the content converted to a
number? Is there a setting to switch off this behaviour?