Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make Excel stop rounding off my numbers that are 16 digi.
Using Excel 2003... I want to type in a 16 digit number without it rounding
of the last digit. In example I type 6038060611469583 and I get 6038060611469580. I give the number enough space and I have tried to go to format and select custom but I cant seem to type in a format that would avoid my number from rounding off. |
#2
|
|||
|
|||
Hi
Excel supports only 15 significant digits. As I doubt you want to calculate with this number try one of the following: - preformat the cell as 'Text' - enter the value with a leading apostrophe. e.g. '6038060611469583 -- Regards Frank Kabel Frankfurt, Germany "Aida" <Aida @discussions.microsoft.com schrieb im Newsbeitrag ... Using Excel 2003... I want to type in a 16 digit number without it rounding of the last digit. In example I type 6038060611469583 and I get 6038060611469580. I give the number enough space and I have tried to go to format and select custom but I cant seem to type in a format that would avoid my number from rounding off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
in excel why do numbers entered get divided by 100? | Excel Discussion (Misc queries) | |||
In excel and a pivot table - how can I stop it displaying (blank). | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |