| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I stop Excel from displaying rounded numbers? Credit car.
I read that Excel displays rounded numbers, though the actual values will
remain the same for calculations. I'm trying to simply input a credit card number (16 digits), and it keeps rounding the last digit down to zero. I can't figure out how to stop this from happening. Any one else know how to prevent this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | 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) | |||
Threaded Mode
