TEXT

Converts a value into text according to a given format.

αžœαžΆαž€αŸ’αž™β€‹αžŸαž˜αŸ’αž–αž“αŸ’αž’β€‹β€‹

TEXT(Value; Format)

Value is the value (numerical or textual) to be converted.

αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™ αž‡αžΆβ€‹αž’αžαŸ’αžαž”αž‘β€‹αžŠαŸ‚αž›β€‹αž€αŸ†αžŽαžαŸ‹β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™Β αŸ” αž”αŸ’αžšαžΎβ€‹β€‹αž…αŸ†αž“αž½αž“β€‹αž‘αžŸαž—αžΆαž‚ αž“αž·αž„β€‹αž’αŸ’αž“αž€β€‹αž”αŸ†αž”αŸ‚αž€β€‹αžαŸ’αž‘αž„αŸ‹β€‹αž–αžΆαž“αŸ‹ αžŠαŸ„αž™β€‹αž’αžΆαžŸαŸ’αžšαŸαž™β€‹αžαžΆαž˜β€‹αžŸαŸ†αžŽαž»αŸ†β€‹αž—αžΆαžŸαžΆβ€‹αž€αŸ’αž“αž»αž„β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž€αŸ’αžšαž‘αžΆΒ αŸ”

αž§αž‘αžΆαž αžšαžŽαŸ

=TEXT(12.34567;"###.##") αžαŸ’αžšαž‘αž”αŸ‹β€‹αž’αžαŸ’αžαž”αž‘ 12.35

=TEXT(12.34567;"000.00") αžαŸ’αžšαž‘αž”αŸ‹β€‹αž’αžαŸ’αžαž”αž‘ 012.35

=TEXT("xyz";"=== @ ===") returns the text === xyz ===

tip

See also Number format codes: custom format codes defined by the user.


Please support us!