In an adjacent column, put this

=ISNUMBER(A1) where A1 is the address of the cell in question

If it's a number, you'll see TRUE, if it's not, you'll see FALSE. What do
you see?
--
HTH,
Barb Reinhardt



"D" wrote:

Hi:

Can you please tell me what would be the reason that for an Access table
exported to Excel, in one col. I cannot format in any way the numbers? no
calculation works?
They display as numbers, formatted as numbers, but for ex. the sum is 0??

Thanks,

Dan