#1
|
|||
|
|||
Incorrect Date!!
Hi....I am having problems with entering dates....if I enter 30/06/23 (UK format), it is showing as 28/01/2723. What settings do I need to change?? Thanks
|
#2
|
|||
|
|||
select the cell you want to edit/place date. then follow image 1 & 2. select the date format you want.
|
#3
|
|||
|
|||
No sorry its not that....have already tried and still showing random date
|
#4
|
||||
|
||||
Suggest you upload a sample file with the incorrect formatting and let us look at what you have. Difficult to diagnose from your explanation. No pictures as they cannot be formatted nor manipulated.
|
#5
|
||||
|
||||
Quote:
That is because : 1. Your cells are formatted as dates 2. You entered a date as a continuous string "300623" which is the background value of the date you get ( or the 300623th day after Jan 1st 1900 which is day 1) You have to enter the date as you would like to see it: first the day, then / then the month then / then the year Formatting is how XL shows things to the outside world,the underlying value, in this case is still a number If you wish to enter a continuous string and that it appears as a date, some VBA or Power Query will help
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link (to Excel cell) Field Date Formatting Showing Incorrect Year | eyefuel | Word | 2 | 06-15-2023 12:32 PM |
Incorrect Date Calculations > 12/31/29 | Oldfart1944 | Excel | 4 | 07-01-2018 11:08 PM |
Baseline Slippage showing incorrect date | jim44 | Project | 0 | 04-29-2018 06:05 PM |
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. | jalea148 | Excel | 3 | 01-06-2017 09:04 AM |
Password is incorrect--but it's not. | orcasguy | Outlook | 2 | 11-10-2011 02:17 PM |