By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

TransferSpreadsheet Macro Problem

P: n/a
I have three of these that run off queries. They work for the most
part except that on every cell, it inserts an apostrophe ( ' ) before
all text. I can't seem to figure out why. The transfer type is
"Export" and the spreadsheet type is "Microsoft Excel 8-10." I am
using Access/Excel 2003. Any suggestions?

Jan 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<nj*********@gmail.comwrote in message
news:11*********************@k21g2000cwa.googlegro ups.com...
>I have three of these that run off queries. They work for the most
part except that on every cell, it inserts an apostrophe ( ' ) before
all text. I can't seem to figure out why. The transfer type is
"Export" and the spreadsheet type is "Microsoft Excel 8-10." I am
using Access/Excel 2003. Any suggestions?
I do not know where your data originates but It is pretty common for server
level data to arrive in a spreadsheet with what I call quoted numerics as
in '2345634 .

When that is the case access 2003 will show a colored triangle in
the cell. If you then highlight an area of those values you will see
a diamond shaped object with a "!" in it. If you click on that it will
offer to convert the cell's content to numbers.

If that is your situation, you can either fix them interatively
as noted above or programatically set a range to
include all the cells so affected and then simply execute a command
of "xlsheet.Range.Value = xlsheet.Range.value" and all quoted numerals
are converted to numbers.

They will then right align and behave in equations as numbers
because they now are numbers.

Good Luck

Kevin C
Jan 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.