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: Format cells in excel 2007

06 Jan 2014   #1
Frank1

Desk Top with Win 7 Home Premium 64 bit and Lap Top with Windows 8.1 Pro 64 bit
 
 
Format cells in excel 2007

I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the zeros. It seems a little dumb--but maybe it's just me. isn't there a way to show everything?


My System SpecsSystem Spec
.

06 Jan 2014   #2
Kaktussoft

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by Frank1 View Post
I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the zeros. It seems a little dumb--but maybe it's just me. isn't there a way to show everything?
It drops zero's after comma so 3,53000 is displayed as 3,53? You want a fixed number of decimals?

00065712 is displayed as 65712? You want a fixed number of characters in front of the decimal comma?
My System SpecsSystem Spec
06 Jan 2014   #3
Frank1

Desk Top with Win 7 Home Premium 64 bit and Lap Top with Windows 8.1 Pro 64 bit
 
 

I simply want 00030260 displayed as 00030260. It's important that it displays it exactly that way.
My System SpecsSystem Spec
.


06 Jan 2014   #4
Kaktussoft

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by Frank1 View Post
I simply want 00030260 displayed as 00030260. It's important that it displays it exactly that way.
It looks like you want to treat it as some kind of product number, actually some sort of identification.

No reason to summarize the values, no reason to order the values? So it's something like a phone number?
My System SpecsSystem Spec
06 Jan 2014   #5
Kaktussoft

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Don't type 00030260 but type:
'00030260

So one quote in front of it
My System SpecsSystem Spec
06 Jan 2014   #6
Frank1

Desk Top with Win 7 Home Premium 64 bit and Lap Top with Windows 8.1 Pro 64 bit
 
 

Yes, it is a product number. Putting the quote mark in front of it took care of it. Thank you
My System SpecsSystem Spec
06 Jan 2014   #7
Kaktussoft

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Glad you solved the problem. You have to edit a lof of them?
My System SpecsSystem Spec
09 Jan 2014   #8
meebers

Windows 7 Professional X64 Service Pack 1
 
 

Putting a " ' " in front, technically converts a number to text. Excel has an option to treat text as numbers when you are doing calculation. Don't know if all your numbers are 8 digits long or if you would mind converting them all to 8 digits but what I do when I want to show a leading 0(s) or what ever is to format the range to a custom format such as this: (choose custom and type in the amount of zero's you want in your format) Then you can type in 30260 and it will automatically show the leading 3 zeros


Attached Images
 
My System SpecsSystem Spec
Reply

 Format cells in excel 2007




Thread Tools





Similar help and support threads
Thread Forum
Excel 2007 (MS Office 2007 enterprise)
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells. I have cleared the cells formatted the number but it still keeps on...
Microsoft Office
Excel: How do I make some cells remain the same when pulling it down?
Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down. Normally it the adds 1 to every cell address,...
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
In Excel 2007 why doesn't locking and protecting cells work?
This is literally driving me nuts. I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel un password cells
Hi I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
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 15:44.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App