How do I format cells to show date in Australian not US format?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Worksheet
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Can i Enlarge a cell by Double Clicking? What i want to do is double click on a calendar date(Monday May 12th) and have a new sheet pop up. Its for budget purposes. Be able to click on a date and then have all my finances pull up for that date is this possible? Tag: How do I format cells to show date in Australian not US format? Tag: 506383
  - 2
    - Adding numbers to text! Hi! Let's say I have a text called "Text" in column A1:A3. In column B1:B3 I have a formula counting number of square foot. In colum C1:C3 I want to output the text in column A combined with the output of column C. C1: Text 1.05 C2: Text 2.94 C3: Text 3.14 That is "Text " and "1,05" Is there a print function or similar? Kind Regards Tag: How do I format cells to show date in Australian not US format? Tag: 506381
  - 3
    - Help on how to use the PARETOINV function! Hi! I want to use the PARETOINV function in Excel 2007. But there is no description on how to enter the parameters or which parameters to use between the brackets. PARETOINV() Can someone give me a short description? Kind regards Tag: How do I format cells to show date in Australian not US format? Tag: 506378
  - 4
    - Link from a drop down list Hi, I have create a workbook with 5 different tabs. Tab 1: Master Sheet Tab 2: xxxxx Tab 3: yyyyy etc,etc My problem starts when I want to link a option drop down list from my "Master Sheet" to a different worksheet within the same workbook. And select the first aviable cell from that assigned colum in the Tab 2, or 3 or where ever I want to send it. Ex: Drop down list in any cell (from Master Sheet/diferent values) 1111 2222 3333 4444 I want to link option 1111 to Tab 2 to a specific colum B to the first aviable empty cell. Or option 2222 to Tab 2, etc, etc..... Seems to me as a cross references!!! Note: I have try "IF", I have try "CHOOSE", and many others. My head spins!!! I hope this make sence. If someone can help me, I will be deeply thankful. Thanks in advance, Jose. Tag: How do I format cells to show date in Australian not US format? Tag: 506377
  - 5
    - Conditional formatting puzzler If you take a look at my example below... We'll say I'm selling widgets. I need my crew to average 4500 widgets in my two week period. I can use conditional formatting to make the number in the "Avg" column green if they sell good, red if they sell bad (or whichever text colors, formats, etc). I've got that down. What if instead of formatting my "Avg" column, I put in a column to designate whether they did "OK" or not? For instance, Ben sold ABOVE the average I'm looking for, and I want a special character like a green check mark to populate in my "OK" column. Conversely, Quark sold BELOW the average I'm looking for, and I want a special character like a red "X" to populate in my "OK" column. I'm sure that it involves some of the IF, THEN, AND stuff that I'm really weak on. Any ideas on this puzzle? Week 1 Week 2 Avg OK? Ben 8627 5136 6882 Julian 3578 5648 4613 Kira 1597 5975 3786 Odo 5684 5812 5748 Quark 3248 5211 4230 Miles 4008 9855 6932 Jake 6032 6871 6452 Dax 5352 8988 7170 Tag: How do I format cells to show date in Australian not US format? Tag: 506368
  - 6
    - how i convert "100" to "hundred"( number to text) in excel-2007 i don't know vb.is there any formula or function in excel 2007 to do the following convertion. number "100" convert in to text"hundred" Tag: How do I format cells to show date in Australian not US format? Tag: 506366
  - 7
    - Auto insert e-mail addresses Hi all I was thinking of setting up a code that will automatically open microsoft office outlook and auto-insert all the recipient addresses. Any idea how I can achieve this as this type of coding is out of my realm of experience. I know through my experience with Access coding I can use the Shell command, but I'm not sure of it's equivalent in Excel or the correct syntax structure. TIA Mark Tag: How do I format cells to show date in Australian not US format? Tag: 506359
  - 8
    - move cursor on limited cells. Hi, I have a sheet which have dozen of cells and rows but i want that someone who ever is using that workbook that could move only on limited cells e.g. only on C3, C15, C48 and E55 the user can edit as well and if a user try to click on any other cell cursor or mouse will not be able to select that Cell. I have already protected that worksheet by password. Please let me know. Thanks F1 Tag: How do I format cells to show date in Australian not US format? Tag: 506358
  - 9
    - unhide row does not unhide the hidden rows hi, I run into this problem where I have hidden rows 1 - 3 and now I can't seem to unhide them. I found the below in online help. however, it still does not unhide the hidden rows. If the first row or column of a worksheet is hidden, click Go To on the Edit menu. In the Reference box, type A1, and then click OK. On the Format menu, point to Row or Column. and then click Unhide. Instead of being hidden, the height or width of the first row or column of a worksheet may have been set to zero. In this case, point to the border of the Select All button until the cursor changes to or , and then drag to widen the row or column. Any ideas are highly appreciated! thanks! Tag: How do I format cells to show date in Australian not US format? Tag: 506351
  - 10
    - Just type the word Hi! Is it possible? For example, lets say in A2 of sheet #1 the data entered in the cell is "ABC Computer Supplies, 123 Main Street, Akron Ohio 21657." Now if I begin typing "ABC" in Sheet 2 that data will automaticly appear and I simply have to hit enter and the data is there Because one of my friend told me that it is possible But unfortunately he also dont know how. Thanks In Advance Hardeep Kanwar Tag: How do I format cells to show date in Australian not US format? Tag: 506349
  - 11
    - Calender function - time sheet - excel 2003/7 (Newcomer please be gentle!) I am trying to set up a monthly time sheet spreadsheet for an organisation that has staff working 7x24. Ideally I should like the spreadsheet to automatically assign the date and day of the week working from user input data (from drop down lists for month, and year) so that for the current month (May 2008) the information would appear as follows:- Day Date Thursday 1 Friday 2 and so on to Friday 30 Saturday 31 Obviously the spreadsheet would need in some way to work off Julian calender data. Is this possible or do I ask too much? Peter Tag: How do I format cells to show date in Australian not US format? Tag: 506345
  - 12
    - Merge multiple row data in one cell with delimieters I have a single row of data, which will grow, which I need to merge into a long list of text in one cell, so I can paste into another program. I have started with the concantenate function, but I could do with a function to automatically go down the list until there is no more data. I think I have seen this done, but I can't remember how. TIA Tag: How do I format cells to show date in Australian not US format? Tag: 506338
  - 13
    - MAX value matching multiple criteria Hi I have a spreadsheet that contains text and time information such as below: a b c 1 north high 5:21 2 south low 6:42 3 north low 7:14 4 north high 3:56 5 east low 2:14 6 north low 2:02 7 north high 2:37 All of the information in the spreadsheet is the result of formulas from other data (in other sheets). I need a formula that will provide the maximum time (in Col C) in a row where (for example) the Col A is "north" and Col B is "high". Any help would be greatly appreciated. Thanks. Tag: How do I format cells to show date in Australian not US format? Tag: 506334
  - 14
    - pay slips I need to find a template for wage/pay slips, can anyone give me any advice on where to find these. Tag: How do I format cells to show date in Australian not US format? Tag: 506329
  - 15
    - Find Smallest entry but excluding zero I need to find the smallest number in a column which may have the range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf so that I can calculate the lowest number of strokes taken. Zere means that they have wiped the hole and therefore cannot be used. Thanks EPJ Tag: How do I format cells to show date in Australian not US format? Tag: 506327
  - 16
    - Sorting and filtering HELP!!!!! I created a pivot table but the end result has many empty blanks and unecessary totals, please does anyone know how I can sort and or filter the columns without messing up my data. I need just clean rows and of data without the spaces and the total. I have 20 columns and thousands of rows All help will be greatly appreciated. Thanks Tag: How do I format cells to show date in Australian not US format? Tag: 506322
  - 17
    - formulas Hi, I need to be able to protect my formulas in a column. I know how to protect the columns I don't want edited. However in the column which I allow data to be input, if someones enters a number in the wrong cell in a row then hits delete it also deletes the formula in the cell so that when they go across the row and come down to the next row the cell has lost its formula. Can someone please help with this Tag: How do I format cells to show date in Australian not US format? Tag: 506312
  - 18
    - Move text Sh1 C5:C40 are text values inserted at various times and not in any order. Sh1 D5:D40 are numbers that were inserted next to name and Sh1 E5:E:40 are additional text values added. In Sh2 C5:C40 are the same text values as Sh1 C5:C40 but in alphabetical order. I am using the SUMIF formula to enter number values into Sh2 D5:D40. Therefore Sh2 D5 formula is SUMIF(C5:C40,C2,D5:D40) etc. I want to fill Sh2 E5:E40 with info from Sh1 E5:E40 same as previous col but cannot use sumif because Sh1colE is text. What formula works? Thanks Tag: How do I format cells to show date in Australian not US format? Tag: 506310
  - 19
    - IF Function formula I posted this in the general questions but it's better suited for here: Hi I need some help figuring out if it is possible to create a formula. I'm trying to link information from different pages in a spreadsheet that contain id's for people and prices they are paying for some items my church is selling. We have a main worksheet that lists their names and the ids and then we have another worksheet that lists all the items they can buy with it's price. Is it possible to create a formula in the name page that says "If you find id #1 in column A, then sum the prices from column D". The ids will be spread out throughout column A so we need a formula to locate each instance of the id and then grab the price listed each time in column D and sum those prices up. Is this possible and if yes can someone tell me how to do it. Thanks Tag: How do I format cells to show date in Australian not US format? Tag: 506304
  - 20
    - How do I ingnore non-numeric cells in Analysis toolpak? When using the Correlation Function in the analysis toolpak, I get an error message if my dataset contains non-numeric fields. Is there a way to get Excel to ignore fields that are non-numeric? Tag: How do I format cells to show date in Australian not US format? Tag: 506294
  - 21
    - Excel - Formulae across several sheets I have a period (4 week) sales goal. As I complete week 1, I need to know how much remains of my sales goal. I created a spreadsheet which tracks sales for many accounts for one week (or sheet) at a time. On sheet 2 I need to subtract the total sales from sheet 1 and show remaining sales goal as of week (sheet) 2. Basically, on week (sheet) 4 I need to know what remains for that week. How do I transfer data from sheet 1 to sheet 2; then cumulatively to sheet 3, and finally, cumulatively to sheet 4. Any help will be sincerely appreciated! HELP!! Tag: How do I format cells to show date in Australian not US format? Tag: 506292
  - 22
    - Formula Funtions Hi, I am working in excell 2000 and I would like to write a formula that would divide a numer in one cell and times the decimal portion of the answer by the same amount I was divding it by. Example cell A1 would countain the amount I entered 5000 I would like cell B1 to divide the amount in A1 by 560 and then times the reaining amount that would be in decilmal by 560. Don't know if this is possible or not? if you divide 5000 by 560 you get 8.928 if you set your decimal point to 3 I would like to take the decimal part and times that by 560 which is 519.680 I would like to round up the 519.680 to the next whole if the first number on the right of the decimal is 5 or higher. then my answer in cell B1 would be 8.520 Thanks if anyone can help with this. Hope my question makes sense. Tag: How do I format cells to show date in Australian not US format? Tag: 506283
  - 23
    - Cash Flow Solution: Eagle Capital Corp Cash Flow Solution: Eagle Capital Corp Same day cash flow to your company. Instant cash that can be used to meet payroll, or simply provide working capital to run your business. http://www.healthhuman.com.cn/Cash-Flow.htm Tag: How do I format cells to show date in Australian not US format? Tag: 506276
  - 24
    - Muti-page workbook highlight specific dates that occur throughout I'm working on a muti-page workbook and want to highlight specific dates that may occur throughout the workbook. I want to be able to type in the date and it automatically highlight that date if it occurs anywhere in the entire workbook. Tag: How do I format cells to show date in Australian not US format? Tag: 506275
  - 25
    - multiple if statements I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to return the following all inclusive result. I can get some of it to work but no all. HELP! And thanks. IF B1>=A1 =NETWORKDAYS IF C1>=A1 =NA IF B1<A1 =ERROR IF C1 OR B1 is blank =0 Tag: How do I format cells to show date in Australian not US format? Tag: 506268
- Next
  - 1
    - custom views troubleshoot i have the error message that view settings could npt be apllied when in excel. the sheet contains data and I want to view certain sections under different and multiple views. Tag: How do I format cells to show date in Australian not US format? Tag: 506267
  - 2
    - Function to calculate total hours worked in one week. I have a spreadsheet that has rows of employees. The header row lists Name, Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end. Each row, under day of week listed the employee's work hours (ex: Under Monday I have 7:36 - they worked 7hrs and 36 minutes). How do I calculate the TOTAL HOURS WORKED for the week? I assume there is a formula, but I can't figure it out for hours:minutes worked per week. Thanks so much for any assistance! Tag: How do I format cells to show date in Australian not US format? Tag: 506256
  - 3
    - when I type 1 it is displayed as 0.01 when I type 1 it is displayed as 0.01 Tag: How do I format cells to show date in Australian not US format? Tag: 506255
  - 4
    - Tabbing to select fields I am setting up a form for multiple users to use, however I would like them to be able to move through the form by tabbing or enter to select fields, i.e. tab from cell a4 to g3 to h20, etc. Can this be done. Confused Tag: How do I format cells to show date in Australian not US format? Tag: 506253
  - 5
    - scroll lock Hi, I am trying to lock the scroll, My range is "a1:ar31", When i save and close the work sheet and open again the scroll lock range dissappears. is there any code???. please help. Thanks in advance. moiz Tag: How do I format cells to show date in Australian not US format? Tag: 506250
  - 6
    - How do i make one cell get just the row amount from another cell? I have a Formula that gets data from another tab EXAMPLE: =' TAB NAME'!$C$16 I want to be able to put a number in a different CELL that will change the 16 on the above formula... so if i a put a 19 in A1, the formula will get information from the other tab, in the C Column, and the 19th row... (not real good with excel terminalogy.. sry) Need this for updating a page... with many different column Letters and the same 16, need to change them all by hand at the moment. Thanks in Advance (please give examples as i may not understand it right away =P) Tag: How do I format cells to show date in Australian not US format? Tag: 506247
  - 7
    - formatting in different countries I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby Tag: How do I format cells to show date in Australian not US format? Tag: 506245
  - 8
    - Need formula Hi, Don't know does this forumula exists in Excel so I need help. I need to count different values in range of cells. Example: I have cell ranges with this values: 13, 14, 15, 16, 13, 13, 16 I need formula which will return: 3 values of 13 1 value of 14 1 value od 15 2 values of 16. Is this possible in Excel? Thank you in advance. Regards. -- Pozdrav, M http://www.unreal-net.com/ Jedini web imenik na kojem mozete zaraditi! http://forum.unreal-net.com/ Jedini forum koji dijeli zaradu sa clanovima! Tag: How do I format cells to show date in Australian not US format? Tag: 506243
  - 9
    - duplicate an array and filter the list based on a grouping I have a list of items in excel that belong to certain groups. (see below) --Sheet 1-- A B 1 Electrical 3.1.1 2 Electrical 3.1.2 3 Electrical 3.1.3 4 Mechanical 3.2.1 5 Mechanical 3.2.2 What I would like to do using array functions is obtain an array of all the items within the same group on another worksheet. (see below) --Sheet 2-- A B 1 Electrical 3.1.1 2 Electrical 3.1.2 3 Electrical 3.1.3 I already have a list of all the distinct items within sheet 1 column A. So this part won't be a problem. Has anybody ever attempted to try this with array functions instead of doing it in VB. If anybody could help me with this or point me in the right direction I would greatly appreciate it. Thanks for any and all help on this subject. Jeff Tag: How do I format cells to show date in Australian not US format? Tag: 506239
  - 10
    - checking for Match Hi there, I would like to use a function that would look at a number in D1, check to see if it exist in range A1: A8, if the number does exist then display the D1 number in the formula cell, else display the number 1. If Number exist! A B C D E 1 5 25 2 9 3 25 Formula> 25 4 1 5 15 6 8 7 3 8 5 If Number does not exist! A B C D E 1 5 11 2 9 3 25 Formula> 1 4 1 5 15 6 8 7 3 8 5 Thank You for any Help! Craig Tag: How do I format cells to show date in Australian not US format? Tag: 506235
  - 11
    - vlookup in the row below the target row I have the following table. part start mid end ABCD plan 01-Jan 01-Feb 01-Mar actual/projected 01-Jan 05-Feb 05-Mar EFGH plan 01-Feb 01-Mar 01-Apr actual/projected 10-Feb 10-Mar 10-Apr With this vlookup formula, I can lookup the plan date - =VLOOKUP("ABCD plan",A2:D5,2,FALSE) but I really want to capture the actual/projected date in the row below the plan row. How do I do this? -- Alan Tag: How do I format cells to show date in Australian not US format? Tag: 506229
  - 12
    - Como criar uma formula que ao atingir uma data esta muda de cor Como posso criar uma formula em Excel/2007 para ao atingir uma data esta muda de cor. exemplo: 10/08/08, quando em tempo real for este dia a data muda para vermelho e como fazer tambÃ©m que o sistema me avise que faltam n? de dias para atingir a data em questÃ£o Tag: How do I format cells to show date in Australian not US format? Tag: 506225
  - 13
    - VLOOKUP using 2 Cells What I want is the lookup to use cells B2 and B3 when it looks up a value Here is my formula now: =VLOOKUP($B$2&$B$3, 'Apr Sups'!$B$2:$J$13,6,0) What am I doing wrong? Tag: How do I format cells to show date in Australian not US format? Tag: 506210
  - 14
    - day increasing by 1 when i drag and drop when I drag and drop a date format the day value increases by one. how do I stop this? Thank you Tag: How do I format cells to show date in Australian not US format? Tag: 506208
  - 15
    - Format Name Can someone please help with a formula? In Column A I have names formatted as SMITH, John. In Column B I need John Smith. Would someone please help with a formula that would switch the names, get rid of the comma, and change the case to lower case of the last name except for the first letter? Thanks in advance! - D. Tag: How do I format cells to show date in Australian not US format? Tag: 506205
  - 16
    - creating sub worksheets Is it possible to group individual worksheets under one general tab??? For example: grouping all of May's worksheets under a specific tab for the month of May???? Tag: How do I format cells to show date in Australian not US format? Tag: 506204
  - 17
    - 3 variable lookup I'm newly impressed with what Excel can allow me to do, but am running into an issue which may or maynot be doable...so please help if you can: I want to find the sales number for a company by year in a sheet that is organized as follows: Column 1 starting row3: Sales Row 1 starting column 2: Company Name Row 3 starting column2: Year company A A A B B B Year 2007 2006 2005 2007 2006 2005 sales 1.20 2.29 2.17 1.14 3.75 3.57 assets 0.90 1.06 1.06 0.47 1.67 1.46 hlookup only works if I want to find sales by year but the additional variable of company name...maybe I'm just not seeing a simple way to do it...? Tag: How do I format cells to show date in Australian not US format? Tag: 506203
  - 18
    - =?Utf-8?Q?Danish_Question_H=C3=86LDNING?= Hi all, For some reason my Danish Excel wont recognize "HÃ?LDNING"? Even copy-paste from the help file won't help and it is not on the drop down menu when I write H. Any clue why? Thanx! Tag: How do I format cells to show date in Australian not US format? Tag: 506197
  - 19
    - SUM if conditions are met over multiple worksheets I am trying to get the sum of all costs in my work book that correspond to a certain reason. I have a summary page with the follwing list: Total $ Amount Architect Design Issues $0.00 Owner Request $0.00 Construction Deficiency $0.00 Errors & Omissions $0.00 CM / Scope Issues $0.00 DSA / Code Requirements$0.00 Unforeseen Conditions $0.00 Value Engineering $0.00 $- I have a separate work sheet for all contracts. Each work sheet has a list of changes to the contract. The sheets have separate columns for description, cost and reason. The reason code can be selected from a list. I want the summary page to total all costs with associated reason. For example I want it to sum the costs of all changes that have a reason code of "Architect Design Issues" Tag: How do I format cells to show date in Australian not US format? Tag: 506195
  - 20
    - Conditional Result based on Multiple Columns I have 3 conditions defined across 3 columns of data, each with 0's or 1's depending on partnership status of an account. If all three conditions / columns are 0, then it is a company direct account. I want to consolidate the date into 1 column (Company Direct, Partnered on Brand Y, Partnered on Brand X, Partner Direct). Would someone please suggest a formula for this, I rarely work with Excel and it is a Friday . . . Tag: How do I format cells to show date in Australian not US format? Tag: 506194
  - 21
    - Using Sumif On Two Columns of Data - How? Here is the problem in a nutshell: Column 1 Column 2 58000 100% 7000 50% 7000 50% 50000 50% 50000 50% I need a function that adds all values in column 1 that are 20000 or higher AND are 50% in column 2, lastly I divide the result by two. I tried something like this: =SUMIF(M158:M163, "50%", (L158:L163,">19999")/2 Didn't work. The correct output using the sample numbers above is 50000.00 Thanks! Tag: How do I format cells to show date in Australian not US format? Tag: 506187
  - 22
    - Vlookup formula - help please...(soth) Hi Sheet A, Sheet B, Column B Column C Column D 101 130 Consulting 103 101 Training 110 120 Hardware 120 103 Software I'd like to have a formula in column E, that is, if items in 'Sheet A' Column B Matches with items in 'Sheet B' Column C, then enter the result in Column D, such as 'Training' Is this something can be done? Thank you, Soth Tag: How do I format cells to show date in Australian not US format? Tag: 506186
  - 23
    - vlookup and Sum unique values Hello, I am trying to do a vlookup on Group Names and return a sum of the unique values only. I have many Group names all over this sheet and much of this is repeated (It is important for that sheet). However I just need to have a sum of all unique values. For example Column A Column B Group Name Number in Group F8 20 F7 30 F7 5 F8 20 F7 10 F8 5 F7 30 F7 5 F8 15 F8 5 F8 15 The reu;lt would return a total of 40 for F8(20 + 15 + 5) and a total of 45 for F7 (30 + 5 + 10) Thanks chris Tag: How do I format cells to show date in Australian not US format? Tag: 506181
  - 24
    - select multiple records in database given conditions I would like to select multiple records from a database matching certain conditions and then extract the information from the record to print on a form. Am using Excel 2003. Tag: How do I format cells to show date in Australian not US format? Tag: 506180
  - 25
    - What-If Analysis Hello, I am trying to conduct a â??what-ifâ?? analysis for a fairly simple financial model. This model is basically one extensive income statement that contains historical data as well as forward-looking statements. Historical data is hard-coded while the forecast data is driven by revenue, expense, and other miscellaneous assumptions. At any given point, I want to manipulate the revenue assumption for the upcoming period to see what the effect would be, not only on that period, but for all future periods. Clearly, the easiest way to do this would be to punch in different assumptions to see what the outcome would be. However, I want to develop something that would outline multiple outcomes (for example, 10%, 30%, or 50% growths) of these revenue adjustments all at the same time. I tried using scenarios (under Tools>Scenarios) and that works great except that it cannot show multiple outcomes all on one page at the same time. I messed around with â??Summaryâ?? function under scenarios, but those outputs seem gear towards one-time analysis rather than for something that would need to be revisited each month. I was wondering if there is any other way to get the Scenarios to â??publishâ?? the effects of different inputs as a separate report that has more functionality and transparency. I also tried using data tables, which work fine if I just want to see different outcomes for one period, but if I want to see how those one period changes would affect other future periods, I would need to build additional steps to implement it into my main model (toggle switches, etc.) Any help/insight will be appreciated! Tag: How do I format cells to show date in Australian not US format? Tag: 506178

I have the language set on Eglish (Australian) but trying to format cells to
show date as 08-May -2008 for example.
NormallyI would type 08/5/08 and it would formated as above. But now if I
type that in it thinks I have typed month in first - like US mehtod. How can
I change?

Top

Re: How do I format cells to show date in Australian not US format? by Fred

Fred
Sun May 11 22:17:16 CDT 2008

Excel uses the date format you have specified in your Windows Regional
Settings. Go to Control Panel, and change your regional settings.

Regards,
Fred.

"Kevin B" <KevinB@discussions.microsoft.com> wrote in message
news:D1EE4B4E-98C9-467F-BCE9-B590550B54A6@microsoft.com...
>I have the language set on Eglish (Australian) but trying to format cells
>to
> show date as 08-May -2008 for example.
> NormallyI would type 08/5/08 and it would formated as above. But now if I
> type that in it thinks I have typed month in first - like US mehtod. How
> can
> I change?

Top