Formula for correction

Question

Previous Topic Next Topic

Formula for correction

Closed

Report

Shamim - Sep 5, 2015 at 02:00 AM
TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

- Sep 8, 2015 at 11:33 AM

Hello,
The date is 12-July-2015 but in Excel the same is showing as 7-Dec-15
please suggest for the correction

Formula for correction
Spreadsheet formula - Articles
Excel @ in formula ✓ - Forum - Excel
1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
How to copy data from one sheet to another in excel using formula - How-To - Excel
The application was unable to start correctly (0xc0000005) google chrome ✓ - Forum - Google Chrome

1 reply

Ask a question

TrowaD · Answer 1 · 2015-09-08T11:33:47-0400

Answer 1 / 1

TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

490
Sep 8, 2015 at 11:33 AM

Hi Shamim,

Apparently the day and month have switch places.

Try adjusting the cells format by hitting Ctrl+1 and find the desired way to display the date.

Best regards,
Trowa

Formula for correction

1 reply

Your reply

Subscribe To Our Newsletter!