Kitz ADSL Broadband Information
adsl spacer  
Support this site
Home Broadband ISPs Tech Routers Wiki Forum
 
     
   Compare ISP   Rate your ISP
   Glossary   Glossary
 
Please login or register.

Login with username, password and session length
Advanced search  

News:

Author Topic: Excel date confusion.  (Read 2668 times)

renluop

  • Kitizen
  • ****
  • Posts: 3326
Excel date confusion.
« on: November 25, 2011, 10:54:00 AM »

I keep detailed records of my power consumption. In it the dates have been formatted as dd/mm/yy. Most have appeared correctly, but I noticed that one had come out as 02/03/2011 against my input for 3 feb 2011(missing year as it is currrent) of 3/2.

I have tried deleting/clearing the affeccted cells and reselecting the format I want. Nothing seems to work. Locale was showing English ( US), which I thought may have  caused the problem, and more likely after a Windows repair. That too did not cure matters.

Suggestions please! :'(
Logged

exo

  • Kitizen
  • ****
  • Posts: 2927
Re: Excel date confusion.
« Reply #1 on: November 26, 2011, 07:24:34 PM »

Ensure your regional language and keyboard are set to English UK .

From your open Excel spreadsheet, right click on the cell in question and select Format cells.
The Format Cells window is now displayed.
Under the Number tab / Category, select Custom and in the right pane, select dd/mm/yy
Click OK to apply the changes.

N.B. This may vary slightly depending on your version of Excel.

exo


Logged

renluop

  • Kitizen
  • ****
  • Posts: 3326
Re: Excel date confusion.
« Reply #2 on: November 27, 2011, 07:56:36 AM »

Thanks for suggestion! :)
In fact it was the  little EN at bottom right of desktop wrongly set, :-[
Logged

oldfogy

  • Helpful
  • Kitizen
  • *
  • Posts: 3568
  • If it ain't broke....... I'll soon fix it.
Re: Excel date confusion.
« Reply #3 on: November 27, 2011, 10:59:23 AM »

Just as a matter of interest, sometimes clicking 'once' on the format icon on the toolbar, then clicking in the cell you want to format will sometimes cure the problem also.
Logged
 

anything