Dear All,
I have some data in ArcGIS software. i have to copy paste the data in to excel sheet. but when i paste, some data got change the format and value.
please find attached image for more details.
EXCEL.PNG
12/10/20 ----> 12/10/2020
10/5 ----> 10-May
6/9/25 ----> 06/09/2025
Please give me a solution.
Thank you
Just precede what you type with an apostrophe (').
Type '10/5 to get 10/5 in the cell.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW,
Thank you for your prompt reply.
Unfortunately i can't edit the data, which is in ArcGIS.
i can copy only.
is there any option to keep apostrophe (') in the cell before pasting?
So that can help to paste the data without changing format.
Once again thank you
@AhsanQatar: You're using Ctrl-V to copy into Excel aren't you?
Just type an apostrophe, then Ctrl-V
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi,
As per my knowledge, your solution is good for only one,
But it has more than 50,000 row and 20 columns data. Please find attached file.
Attachment 646285
Attachment 646286
Even i can't edit there.
Please give a solution.
Thank you for your reply.
Forum says "Invalid attachment"
Format the cells as Text beforehand. Then copy the data from ArcGIS, and in Excel do Paste > Match Destination Formatting.
Entia non sunt multiplicanda sine necessitate
Dear,
Thank you so match
It's working. It's a very good solution.
And thank you every one who try this one.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks