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: Formatting in Excel 2010

05 Nov 2014   #1
Franky

windows 7 32-bit
 
 
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?


My System SpecsSystem Spec
.
05 Nov 2014   #2
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

What is "number group"? I don't see that on my Excel 2010 screen.

Are you asking why cells can be formatted in many ways?

Personal preference is one reason.

More explanation needed.
My System SpecsSystem Spec
05 Nov 2014   #3
Franky

windows 7 32-bit
 
 

In Home tab, there is some group named Number.
Why we format cells? Just for appearance?
My System SpecsSystem Spec
.

05 Nov 2014   #4
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

Appearance, national or regional custom, readability, company standards, pure personal preference, style standards, etc.
My System SpecsSystem Spec
05 Nov 2014   #5
Franky

windows 7 32-bit
 
 

Thank you very much.
My System SpecsSystem Spec
05 Nov 2014   #6
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

One really obvious answer would be to be able to convey that the number was a currency value or not. For instance the number 123.45 might be a currency value or just a decimal value. However, if we format it like $123.45, it's obvious that it's a currency value.

Something like that may not be important if you created and used the spreadsheet for yourself and no one else ever looked at it but if you sent it to a co-worker who had no prior knowledge of the spreadsheet, it could make things much clearer for them.
My System SpecsSystem Spec
05 Nov 2014   #7
Franky

windows 7 32-bit
 
 

Thanks so much for your help
My System SpecsSystem Spec
Reply

 Formatting in Excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Outlook 2010 - Formatting non read titles
Hello, How do I format the titles of non-read messages in my Outlook 2010? I wish I could format them in bold and color so they willl standout among the read ones, allowing me not to forget about them. I understand this formatting is possible, but don't know how to do. Help will be...
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Keep formatting in protected word templates 2010
Hi all, I need to protect a template that contains parts, that should be edited eventhough there is protection activated. These fields should have a special formatting (font and size) which is missing after protecting the document. How to fix this? Only possible with a macro? Tried to do it...
Microsoft Office
Table Formatting in OneNote 2010
I am trying to use tables for the firs time in OneNote 2010 and have noticed that I don't have all the same formatting options that I do in Word 2010. Is this a limitation of OneNote 2010? Or am I just not finding the options? In particular, I want to "fix the width of columns" - something...
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 06:00.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App