I am importing an MS Access 2007 .mdb table into Excel 2007 as a pivot table.
When I include bookings in the Values section and change display type from
count to sum, I see 0.00.

One issue I discovered is that Excel is importing numbers as text, which I
think is a bug. When I use error checking to correct, by converting "number
stored as text" to number, I am still unable to see bookings values in the
pivot.

Any idea of what's going on and how to correct?
Thanks