Keegan4123
New Member
- Joined
- Mar 30, 2022
- Messages
- 29
- Office Version
- 2016
- Platform
- Windows
I have 4 monthly reports that include fuel card numbers such as 806970520261068615, when copying them in they are auto rounded to 806970520261068000 and display as 8.06971E+17
If I was pasting them in by them selves it wouldnt be a big deal to add the ' to the number before to stop them from auto rounding, but its being brought in as a big batch of data so I then have to search them all out and retype them.
Any way to stop this?
If I was pasting them in by them selves it wouldnt be a big deal to add the ' to the number before to stop them from auto rounding, but its being brought in as a big batch of data so I then have to search them all out and retype them.
Any way to stop this?