{"id":241,"date":"2018-06-27T16:03:30","date_gmt":"2018-06-27T16:03:30","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=241"},"modified":"2024-03-14T13:06:38","modified_gmt":"2024-03-14T13:06:38","slug":"introduction-to-number-formatting","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/introduction-to-number-formatting\/","title":{"rendered":"Number Formatting"},"content":{"rendered":"\n
If a cell is not formatted to a particular type, Excel will read that value and try to guess what format should it be. For example, if you enter the value 12<\/strong> or 2.4<\/strong>, Excel will treat this value as a decimal number. If you enter 4 1\/5<\/strong> it will be treated as a simple fraction.<\/p>\n\n\n\n Excel treats entered value as a number, only if it doesn\u2019t contain any additional characters. Otherwise, Excel will treat this value as text. For example, 5A<\/strong> will be treated as text, not as number 5<\/strong>.<\/p>\nCAUTION<\/cite><\/blockquote>\n\n\n\n In the Format Cells<\/strong> Ctrl + Shift + F<\/span><\/strong> window, in the Number<\/strong> tab, you can change data formatting by selecting one of the available predefined formats.<\/p>\n\n\n\n When you create a new worksheet, each cell has a default cell format- General.<\/strong> All cells from a newly created worksheet will use this data type<\/a>.<\/p>\n\n\n\n These are a few rules that characterize this type:<\/p>\n\n\n\n Example 1:<\/strong><\/p>\n\n\n\n The numbers in cells B2, C2,<\/strong> and D2<\/strong> are the same as the numbers in cells B3, C3, and D3.<\/strong><\/p>\n\n\n\n\n
Number formats<\/h2>\n\n\n\n
General<\/h3>\n\n\n\n
\n