| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number insert
any help on this would be appreciated , i am trying to insert a 20 digit
number into a work sheet, but it does not appear as i want it example: 74540182653438069674 is what i want but what appears is 7.45402E+19 also in the bar under the tools (sorry not sure what it is called) the number there changes to 74540182653438000000 thanks in advance for any help JKF |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a decimal into a whole number. 100 to 1.00 | Excel Discussion (Misc queries) | |||
| insert zero before number | Links and Linking in Excel | |||
| Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
| How do I insert .00 after a number | New Users to Excel | |||
| Insert row number into a cell? | Excel Worksheet Functions | |||
![jkf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
