[AccessD] Access to Excel - #Num!

John
Formatting just addresses presentation, not the
actual content of the cell. Look in the FORMULA
bar; do you see just 1234 ( a number ) or '1234
( 1234 as text ).

Dave


> 
> From: "John W. Colby" <jcolby at ColbyConsulting.com>
> Date: 2003/03/19 Wed PM 03:35:20 EST
> To: <accessd at databaseadvisors.com>
> Subject: RE: [AccessD] Access to Excel - #Num!
> 
> 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/9bd1cf2b/attachment-0001.bin>