Share via

Paste in Excel

Boopathi S 3,806 Reputation points
2022-05-24T15:33:23.507+00:00

Hello,

I am copying 000025E4 in Excel but it paste as 250000. Find the below screenshot

205169-capture.jpg

How can i paste it as 000025E4? Please help

Microsoft 365 and Office Excel For business Windows
Accepted answer
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2022-05-25T07:24:12.567+00:00

    Hi @Boopathi S ,

    1. Right click the cells you want to paste values- select Format Cells...- format the cell to TEXT:
      205327-6.png
    2. Paste the data:
      205346-7.png
      Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2022-05-25T07:33:55.897+00:00

    Or other option, add a apostrophe in front, otherwise Excel interpret it as an exponential number => 

    '000025E4
    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.