So i have computed all my data in different spreed sheets and their is an urgent need to transfer/copy and paste all data to a single spreed sheet for easy processing, but i observed a constant distortion of my data especially numbers. The zeros infront of say phone numbers also disappears.. Plz house, what could be the solution to this problem? And for the data distortion upon copy and paste,how to i go about this? Thanks you all for anticipated response.

jefy:
So i have computed all my data in different spreed sheets and their is an urgent need to transfer/copy and paste all data to a single spreed sheet for easy processing, but i observed a constant distortion of my data especially numbers. The zeros infront of say phone numbers also disappears.. Plz house, what could be the solution to this problem? And for the data distortion upon copy and paste,how to i go about this? Thanks you all for anticipated response.

u need to format the whole excel u are copying if some are formatted and some are not then there will be data distortion and for zeros disappearing u need to start with apostrophe before imputing the zero

Thanks for the tips ,will work on it.