Wrong number format in Danish Excel

Wrong number format in Danish Excel
2

Upvotes

Upvote

 Jan 01 2018
4 Comments (4 New)
Completed

 2018-01-02_00-02-52.png

 

Description of issue

Wrong number format for Danish social security number ("personnummer")

 

Steps to reproduce your issue

Open the Format cells dialog box and select the Number tab

 

Insider Build number

macOS 16.9 (171226).

Windows 1801 (8911.2016).

 

Platform

macOS and Windows.

 

Screenshot of the issue

Inserted.

 

Current translation

## ## ##-####

 

Suggested translation  

0#####-####

 

English text (if known) 

Not known.

 

Reason why you feel the current translation should change

The Danish personnummer (or CPR) is always written without any spaces and should show a preceding zero if typed since the first six numbers are date of birth (DDMMYY).

 

Other info

This is relevant for all versions of Excel since version 1.

Comments
Microsoft

Thanks for reporting the format issue @Jørgen Koch. Our Danish moderator will take a look at them and we will report back in our Power BI Dashboard. Regards, Declan

Copper Contributor
Status changed to: Working on it
 
Microsoft
Status changed to: Completed
 
Microsoft

Hi @Jørgen Koch

This was fixed in March 2018. Thanks for letting us know about it!

Staff