John W. Colby
jcolby at ColbyConsulting.com
Wed Mar 19 14:37:00 CST 2003
I tried formatting the column as a number, no help John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mcgillivray, Donald [LTD] Sent: Wednesday, March 19, 2003 2:43 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access to Excel - #Num! John, I've run into that when the "number" in Excel is actually a "text" value. Try converting the offending Excel value to a number using Excel's "Value" function. In my case that always took care of the problem. HTH Don McGillivray -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, March 19, 2003 11:20 AM To: AccessD Subject: [AccessD] Access to Excel - #Num! does anyone know what #Num! is in a Excel cell? The data if clicked in the spreadsheet is a number, but when viewed in a linked table is #Num! John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2224 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030319/2c9763ad/attachment-0001.bin>