Meta tags:
description=Excel Tips, Tricks and knowledge.;

Headings (most frequently used words):

blog, excel, search, this, try, searching, translate, subscribe, to, archive, 2007, popular, posts, visits, changing, date, formats, in, working, with, credit, card, numbers,

Text of the page (most frequently used words):
the (59), you (33), date (20), excel (18), that (15), and (14), #format (14), with (13), this (10), january (10), number (10), want (8), can (7), cell (7), well (7), your (6), chart (6), from (6), posts (6), card (6), share (6), how (5), for (5), use (5), are (5), when (5), example (5), beginner (5), credit (5), change (5), have (5), select (5), months (5), type (5), 2015 (5), professor (4), data (4), dashboard (4), easy (4), know (4), based (4), was (4), comments (4), digit (4), first (4), text (4), then (4), days (4), customize (4), dialog (4), window (4), values (3), sales (3), all (3), help (3), range (3), has (3), vlookup (3), two (3), email (3), using (3), june (3), july (3), september (3), october (3), november (3), december (3), february (3), march (3), atom (3), home (3), numbers (3), enter (3), why (3), would (3), what (3), yourself (3), cells (3), review (2), dynamic (2), dashboards (2), previous (2), there (2), top (2), large (2), good (2), multiple (2), not (2), other (2), day (2), asked (2), could (2), problem (2), they (2), gantt (2), formatting (2), who (2), location (2), left (2), sum (2), worksheet (2), background (2), averageif (2), coded (2), average (2), between (2), dates (2), speedometer (2), august (2), april (2), may (2), blog (2), subscribe (2), labels (2), pinterest (2), facebook (2), blogthis (2), posted (2), ever (2), down (2), information (2), control (2), display (2), time (2), years (2), yyyy (2), mmmm (2), jan (2), changed (2), versatile (2), way (2), now (2), something (2), about (2), feature (2), region (2), will (2), start (2), see (2), reading (2), changing (2), perhaps (2), any (2), formats (2), awesome, inc, theme, powered, blogger, visits, wanted, greater, detail, make, charts, examples, designing, simple, user, interface, times, generate, low, small, function, bottom, here, graphics, columns, worksheets, difficult, navigate, especially, true, tabs, formulas, does, exce, references, rename, manager, stopped, desk, them, were, having, creating, conditional, anyone, used, while, uses, below, pull, back, employee, index, match, approached, workers, had, needed, total, their, backg, color, over, weekend, received, pam, she, experiencing, difficulties, posting, reference, instead, hard, find, ranges, earlier, described, sumifs, countifs, get, averageifs, return, graph, comprised, components, give, illusion, one, image, donut, gas, gauge, popular, 2007, archive, translate, advanced, intermediate, try, searching, search, older, into, discovered, changes, last, zero, comes, handle, only, digits, numerical, accuracy, need, manually, ask, secure, enough, store, valuable, still, proceed, ways, entering, dashes, spaces, embedding, non, numeric, character, such, dash, forces, interpret, entry, pre, choose, drop, precede, apostrophe, interprets, string, rather, than, working, matter, next, spare, minute, work, broaden, knowledge, wow, boss, mad, crazy, skills, 1900, 9999, sunday, saturday, dddd, sun, sat, ddd, letter, month, mmmmm, dec, mmm, following, guide, click, close, modify, anyway, highlighted, yellow, arrow, displays, beginning, post, mentioned, little, imagination, perfect, say, did, hope, continues, ahhhhh, another, notice, types, available, selection, also, reflect, standard, nomenclature, lets, options, asterisk, special, computers, regional, settings, panel, handy, send, overseas, office, let, put, mind, hat, continue, right, saying, hold, doesn, tell, don, category, list, press, ctrl, bring, additionally, access, ribbon, tab, selecting, displayed, ease, tool, allows, output, almost, imagine, look, doing, thursday, different,

Text of the page (random words):
excel professor changing date formats in excel no matter how you display it a date is a date different date formats 1 15 2015 thursday january 15 2015 1 15 01 15 15 january 15 2015 15 jan 2015 j 15 so why would you want to change the look of a date and how would you go about doing it well excel is a versatile tool and allows you to customize your output any almost any way you can imagine perhaps the cell has the date of january 15 displayed as 1 15 for ease of reading perhaps you want it to be january 15 changing the date format is easy first start by selecting the cells with the dates that you want to format press ctrl 1 to bring up the format cells dialog window additionally you can access this dialog window from the ribbon home tab number in the category list select date select the type of format you want right now you are saying to yourself hold on i know that why doesn t he tell me something i don t know well let me put on my mind reading hat and continue lets start with the type options do you see the first two with an to the left well when you see a date format that has an asterisk then that is a special date format that will change if you change the computers regional and time settings from the control panel that feature could be handy when you have to send your worksheet the overseas office what about the location feature of the format cells dialog window have you ever changed that to another region if you do you will notice that the types available for selection also change to reflect the standard date nomenclature of that region ahhhhh you say to yourself now that s something i did not know i hope he continues well at the beginning of this post i mentioned that excel is versatile with a little imagination you can customize the date format in a way that s perfect for you from the dialog window select the type customize well you can click on the type that is close to what you want then modify the type anyway you want highlighted with the yellow arrow in this example i have changed the date to be yyyy dd mmmm this displays my date as 2015 15 january use the following guide to help customize your date display format to use months as 1 12 m months as 01 12 mm months as jan dec mmm months as january december mmmm months as the first letter of the month mmmmm days as 1 31 d days as 01 31 dd days as sun sat ddd days as sunday saturday dddd years as 00 99 yy years as 1900 9999 yyyy so the next time you have a spare minute at work broaden you date formatting knowledge in excel and wow your boss with your mad crazy excel skills beginner date format posted by excel professor no comments email this blogthis share to x share to facebook share to pinterest labels beginner date format working with credit card numbers credit card numbers are 16 digit numbers and if you ever enter a 15 digit number into a cell you may discovered that excel changes the last digit to a zero so why would excel change this number it comes down to how excel was coded excel can handle only 15 digits of numerical accuracy so what do you do if you need to enter a 16 digit number manually well first ask yourself if excel is secure enough to store valuable credit card information if you still want to proceed you have 3 easy ways of entering in the information precede the credit card number with an apostrophe excel then interprets the data as a text string rather than as a number pre format the cell or range by using the text number format select the range choose home number and then select text from the number format drop down control enter the card number with dashes or spaces embedding a non numeric character such as a dash forces excel to interpret the entry as text beginner posted by excel professor no comments email this blogthis share to x share to facebook share to pinterest labels beginner credit card older posts home subscribe to posts atom search this blog try searching beginner intermediate advanced translate subscribe to posts atom posts all comments atom all comments blog archive january 1 november 2 july 2 june 2 april 2 march 4 february 2 january 1 october 2 september 2 march 2 february 3 january 3 december 3 november 3 october 5 september 3 august 4 july 4 june 4 may 2 april 5 march 4 february 2 january 5 december 4 november 4 october 3 september 4 august 6 july 6 june 19 excel 2007 popular posts speedometer chart gas gauge chart a speedometer graph is comprised of multiple components to give the illusion of one chart the background is an image or donut chart the averageifs to return an average between dates i was asked to find the average sales between two date ranges well in earlier posts i described how to use sumifs and countifs to get the s averageif using cell reference instead of hard coded date over the weekend i received an email from pam she was experiencing difficulties using the averageif example from a previous posting of mi sum based on cell background color the other day i was approached by two of my co workers who had a problem they needed to sum the total of their worksheet based on the backg vlookup to the left with index match anyone who has used excel for a while uses vlookup in the below example i use vlookup to pull back the location of an employee based gantt chart with conditional formatting easy the other day a manager stopped by my desk and asked me if i could help them with a problem they were having with creating a gantt chart cell references rename a cell or range large worksheets can be difficult to navigate this is especially true when there are multiple tabs and formulas it does not help that exce sales dashboard here is an example of a good sales dashboard all the graphics are based on the data in columns b c and d this is a good example dashboard top 5 values bottom 5 values there are times when we want to generate top and low values on dashboards it s easy when you know the large and small function in t dashboard dynamic data designing a simple user interface i wanted to review in greater detail how to make your data dynamic for use in charts and dashboards you can review 2 previous examples of t visits excel professor awesome inc theme powered by blogger