Ask Your Question

Why does =TEXT(0,"###") return nothing?

asked 2020-06-29 04:53:11 +0200

codevark gravatar image

The 0 could be a cell ref that contains 0, or another formula that returns 0.

Is this intended behavior? A bug?

edit retag flag offensive close merge delete


Try =TEXT(0,"#,##0"). I think the "###" format is useful for accounting applications, and maybe where you want to put the emphasis on the numbers that do have a value. Cheers, Al

Earnest Al gravatar imageEarnest Al ( 2020-06-29 06:16:49 +0200 )edit

Avoid the point as group separator in numbers. It's explicitly deprecated by ISO standards (ISO 31-0) for good reasons.
Also consider

Lupp gravatar imageLupp ( 2020-06-29 09:34:50 +0200 )edit

Sorry. Point taken; separator for functions too. Cheers, Al

Earnest Al gravatar imageEarnest Al ( 2020-06-29 10:10:07 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-29 06:44:30 +0200

This is the intended behaviour. # is used to display a number, unless this digit and all potentially visible digits to the right of it are zero. That way you can avoid displaying trailing zeroes - and for your 0, all digits are the trailing zeroes.

See Number format codes in help.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-29 04:53:11 +0200

Seen: 35 times

Last updated: Jun 29