ExcelBanter - Copy and Paste Number from Notepad

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy and Paste Number from Notepad (https://www.excelbanter.com/excel-discussion-misc-queries/126659-copy-paste-number-notepad.html)

Carter68

Copy and Paste Number from Notepad

I have a list of numbers that we are trying to copy and paste from Note Pad
to Excel. When we change the format in Excel from text to a number, it
changes the last digit to "0". Please help!

Notepad:
4233750100024844
4233750100046276

Excel:
4233750100024840
4233750100046270

Mike

Copy and Paste Number from Notepad

all is revealed here
http://support.microsoft.com/default.aspx/kb/269370

"Carter68" wrote:

I have a list of numbers that we are trying to copy and paste from Note Pad
to Excel. When we change the format in Excel from text to a number, it
changes the last digit to "0". Please help!

Notepad:
4233750100024844
4233750100046276

Excel:
4233750100024840
4233750100046270

Carter68

Copy and Paste Number from Notepad

Mike, you are a lifesaver!!

Thanks a bunch!

"Carter68" wrote:

I have a list of numbers that we are trying to copy and paste from Note Pad
to Excel. When we change the format in Excel from text to a number, it
changes the last digit to "0". Please help!

Notepad:
4233750100024844
4233750100046276

Excel:
4233750100024840
4233750100046270

All times are GMT +1. The time now is 04:13 PM.