| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird Number in Excel 2003
I have about 400 rows of information and some of my numbers display as:
1.0202E+12, however in the formula bar it looks like this:1020201010401. I'm trying to create a VLookup and I keep getting a Value is not available and I think it may have to do with the way the number displays. How can I display what is showing in the formula bar without using an ('). Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - negative following the number | Excel Worksheet Functions | |||
| Weird format to formula transition excel 2003 | Excel Worksheet Functions | |||
| demial number being replace by a square box...weird | Excel Discussion (Misc queries) | |||
| if a number is less than -1000 in Excel 2003 | Excel Worksheet Functions | |||
| Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
Threaded Mode
