Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: cell formatting in excel 2010

16 Mar 2019   #1
phoenixmark

win7 professional 64 bit
 
 
cell formatting in excel 2010

I need some help in cell formatting using excel 2010. Wen I copy a 12 digit number (i.e. 163589453609), and paste it in a cell, this is what is shown 1.5358E+11. To get the actual number to be shown, I have to to the function cell and put a ' in front of the number to get the full 12 digit number to be shown in the original cell. I tried what I think are all the choices in the format cell drop down menus. Any ideas? Thanks
Mark


My System SpecsSystem Spec
.
16 Mar 2019   #2
johnhoh

Win7 pro x64
 
 

format all cells using

right click > format > number
or
right-click > format > custom > 0

could also be that your pasting defaults are messed up. When you paste select paste special and make sure it is set to "all", so that both the cell number as well as the cell format gets pasted.

If you are still having issues post a couple screen shots
My System SpecsSystem Spec
16 Mar 2019   #3
phoenixmark

win7 professional 64 bit
 
 

Thanks for the suggestions. They work but I have to do it for each cell that displays like this. I even tried it by highlighting the complete column and trying this but the next number I add still shows up xxxxxE+11. If it helps, these are numbers I copy from ebay auctions to track pricing trends on items I'm interested in buying in case I locate these items into make sure the sellers price is in line with what they normally sell for. I don't know how to post a diredt screenshot, but did attach a Word document.


Attached Files
File Type: docx Doc1.docx (174.8 KB, 1 views)
My System SpecsSystem Spec
.

16 Mar 2019   #4
johnhoh

Win7 pro x64
 
 

Quote   Quote: Originally Posted by phoenixmark View Post
If it helps, these are numbers I copy from ebay auctions to track pricing trends on items
By default excel keeps BOTH the contents and the formatting of a cell being copied, and an external number like copying from ebay will copy over both the item number and its formatting. So that's the problem.

There are many ways to fix this but the easiest is to change your method just a little. Right now you are doing this:

a) on the ebay window you highlight the number > right-click > copy
b) on the excel window you left-click > paste

whereas doing this will solve your problem

a) on the ebay window you highlight the number > right-click > copy
b) on the excel window you left-click TWICE > paste > enter

the second left-click in excel puts you into cell edit mode which does NOT copy over the original formatting.

A second way to do this is: see that little icon on cell B2 in your screenshot? After selecting paste, click that icon which will bring up two options. Click the option that says "Match destination formatting"
My System SpecsSystem Spec
Reply

 cell formatting in excel 2010




Thread Tools




Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
Formatting in Excel 2010
Hello all, In Excel 2010 there are many formats for cells in Home > number group > drop-down list. And also by Format Cells dialog box. My question is, why we use those formats? Is there any benefit for it please?
Microsoft Office
Excel 2010 Multiply cell
I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this? Thanks
Microsoft Office
Microsoft Excel 2010 - chart formatting question
Hello, I've just made a pretty decent scheme in my Excel. It's all good but I would like it to fill a whole A/4 sized piece of paper, by increasing the size of the cells as well as the text in them proportionally, so that I don't have any unused, blank cells. Is there a simple way to do this? ...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:48.
Twitter Facebook