ExcelBanter - date entry using . not /

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - date entry using . not / (https://www.excelbanter.com/excel-discussion-misc-queries/240741-date-entry-using-not.html)

Klonger

date entry using . not /

I want to enter dates using number pad and want to use . as seporator not /

Jacob Skaria

date entry using . not /

Try changing that in Windows StartSettingsControl PanelDate, Time,
Language, and Regional OptionsChange the formats of numbers,dates, and times

If this post helps click Yes
---------------
Jacob Skaria

"Klonger" wrote:

I want to enter dates using number pad and want to use . as seporator not /

All times are GMT +1. The time now is 03:49 PM.