Date input

[sveinhelge.urdal]

I use the numpad for inserting dates in excel.

I find it annoying that Icant use the , key but have to use the . key instead.


i

I use the input format dd.mm.yyyy if I use dd,mm,yyyy excel doesn't reckognise it as a date.


Any sugestions?

Is that something thaty can be fixed in excel?

 

[SirJB7]

Hi, sveinhelge.urdal!

Tried to input the day as dd/mm/yyyy? It's in the numpad too and it should work.

By the way, what Excel version are you using? I use a spanish 2010 and have a comma in the dot/supr numpad key, which is the decimal point separator in the regional configuration of the machine. What reg conf do you use? Actually, decimal and digits separators and date formats.

Regards!

 

[sveinhelge.urdal]

Thanks, that works fine.

I'm using Excel 2003 English and Norwegian keybord

 

[SirJB7]

Hi, sveinhelge.urdal!

Great, welcome back whenever you need.

Regards!