Dilema

  • Thread starter Thread starter Abdul Qayyum
  • Start date Start date
A

Abdul Qayyum

Dilema

I have a problem in date formate.
I want to put the date as "day-month-year"
but in excel some cells behave differently like "day/month/year"
that creats dishormony in the date column.
Please help me in this regard.

Qayyu
 
Hi
preformat your cells with the custom format ('Cells - Format - Custom):
DD-MM-YYYY
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Dynamic border formatting based on dates. Use VBA? 1
Problem with Excel Dates 11
Conditional Formatting based on dynamic Date 1
How to import data 3
Help with formula 3
Date formulas in Excel 1

Back
Top