ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Dates (https://www.excelbanter.com/new-users-excel/106155-dates.html)

mnair

Dates
 
Hi,
Can any one of you please help me to get rid of the default excel dates to
standard format dates.

Bob Phillips

Dates
 
You need to set the format yourself, FormatCellsCustom

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mnair" wrote in message
...
Hi,
Can any one of you please help me to get rid of the default excel dates to
standard format dates.




Muhammed Rafeek M

Dates
 
Go Control Panel-Regional and Language Options: Click Customize-Date
format. Change which format you want, once you change, you will get that
format only in your all applications

"mnair" wrote:

Hi,
Can any one of you please help me to get rid of the default excel dates to
standard format dates.



All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com