Ask Your Question
0

Number formatting with decimal comma

asked 2019-09-20 11:19:53 +0200

bleke gravatar image

updated 2019-09-20 11:23:48 +0200

I've created a new format code: #,##" dl"

It works as expected when used with integers or formulas: "14" becomes "14 dl" and "=15/2" becomes "7,5 dl".

The problem arises when I type a decimal value into the box. Like "1,5". The expected result is "1,5 dl", but what I get is "###".

Why is that?

edit retag flag offensive close merge delete

Comments

'###' normally indicates that the column is not wide enough to display the contents; try widening the column and see what happens. You may find an error code.

robleyd gravatar imagerobleyd ( 2019-09-20 11:35:33 +0200 )edit

Facepalm... lots of agitation over a simple mistake.

Thanks.

bleke gravatar imagebleke ( 2019-09-20 11:39:52 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-09-20 12:15:44 +0200

robleyd gravatar image

'###' normally indicates that the column is not wide enough to display the contents; try widening the column and see what happens. You may find an error code.

Posted as an answer to help others with the same problem.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-20 11:19:53 +0200

Seen: 22 times

Last updated: Sep 20