Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rajeshkumar
 
Posts: n/a
Default How can i paste a 16 digit number in a excel worksheet?

When i try to paste a 16 digit number in a excel worksheet, i got the number
in the exponential form, when i format that cell to make it as a real number
i find the last digit is missing replaced by "0", can you help it out in the
issue.Am Using Excel 2000
  #2   Report Post  
Posted to microsoft.public.excel.misc
beechum1
 
Posts: n/a
Default How can i paste a 16 digit number in a excel worksheet?


select the cell or cells, or column or row, or range, and right
clickFormat cells, and in the number tab, select text. This allow
data entry to be displayed exactly as entered.

I copy and paste tracking #'s that start with a zero into mine, i've
yet to 100% of the time, open the workbook, copy and paste, without
having to format cells everytime. SO, if that happens to you, don't
feel too bad.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=503590

  #3   Report Post  
Posted to microsoft.public.excel.misc
Rajeshkumar
 
Posts: n/a
Default How can i paste a 16 digit number in a excel worksheet?



"beechum1" wrote:


select the cell or cells, or column or row, or range, and right
clickFormat cells, and in the number tab, select text. This allow
data entry to be displayed exactly as entered.

I copy and paste tracking #'s that start with a zero into mine, i've
yet to 100% of the time, open the workbook, copy and paste, without
having to format cells everytime. SO, if that happens to you, don't
feel too bad.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=503590



HI

I tried as per your saying, but still i face the same problem... Can
someone give any idea to get out of this issue... because i have to copy some
of 2400 list of numbers in a worksheet, that i cannot change the last digit
of each and every no.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
excel - numbers as text Thuferhawat New Users to Excel 12 January 24th 05 10:29 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"