| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
my excel change data
i am typing the following number 8920033000001887773 then enter and it
becomes 8920033000001880000 I don't know why but i tried to change format cells but nothing knew |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my excel change data
Put an apostrophe in front of the characters. Excel only maintains 15
digits of precision for true numbers. Mohamed wrote: i am typing the following number 8920033000001887773 then enter and it becomes 8920033000001880000 I don't know why but i tried to change format cells but nothing knew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| in EXCEL, can't change data | Charts and Charting in Excel | |||
| How can you change the x-y axis of data in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I change a data table if Excel won't let me do anything? | Excel Discussion (Misc queries) | |||
| Excel 2007 change data source | Excel Discussion (Misc queries) | |||
Linear Mode
