Forum Discussion
Solved
Date Formatting
I wonder if anyone could help me please? Its probably really simple but I can't for the life of me get Excel to do as I would like. On all our company graphs/pivots etc, date is displayed as ...
- In your file, the value in A2 ia not a true date, but in fact text. But as soon as you edit that cell, Excel will try to assess what you entered, recognize the entry as a date and enter a true date into the cell. To avoid all of this, before making ANY edits to your data, Format the column in question as Text. Then do your edits.
No this problem has been around for years and is due to how data is entered or imported into Excel. If the source of the data is text, Excel will mark the values as text. So you need a way to convert the values to dates before creating pivottables.
Hi
i have a similar problem however converting my column to text didn't help. In the cell the date is displayed thus:
| 05-Oct-1980 |
On the ribbon the date is displayed thus:
10/5/1980
I am trying to strip out the year from the dob so I can calculate the age.
Please help,
Catherine
- A simple way is to use the YEAR function in another cell. To calculate the age you can also use the DATEDIF function as shown here: https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c