| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel link shows zero value instead of actual amt
Linked cell to data in another cell, but the results show as zero (when the
linked cell actually equals 100,000). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel link shows zero value instead of actual amt
Check that your source data cell actually contains a number, rather than
text. If in doubt, try ISNUMBER(cellref). -- David Biddulph "Deb" wrote in message ... Linked cell to data in another cell, but the results show as zero (when the linked cell actually equals 100,000). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a virtual link in Excel | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| link excel data to word document template | Excel Worksheet Functions | |||
| How can you remove a redudant Excel link | Excel Worksheet Functions | |||
| Link from webpage to excel sheet | Excel Discussion (Misc queries) | |||
Linear Mode
