# Qlik Sense on AWS & Azure

Discussion board where members can learn more about Qlik Sense deployments on Public Cloud Infrastructures such as AWS and Azure.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New Contributor II

## I need to convert a number into a certain format text

Good afternoon!

I am looking to convert a number into a certain format text.

EX. 123 Into 00123

3345 ->  03345

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: I need to convert a number into a certain format text

Try like this:

=Num(123, '00000') and

=Num(3345, '00000')

In general, Num(FieldName, '00000')

5 Replies
MVP

## Re: I need to convert a number into a certain format text

Try like this:

=Num(123, '00000') and

=Num(3345, '00000')

In general, Num(FieldName, '00000')

MVP & Luminary

## Re: I need to convert a number into a certain format text

Hi,

You can format numbers using the Num() like below

=Num(123, '00000') and

=Num(3345, '00000')

From Qlik Help file

Example:

The examples below assume the two following settings:

 Default setting 1 Default setting 2 Number format # ##0,# #,##0.#

num( A, '0.0' ) where A=35648.375 returns:

 Setting 1 Setting 2 String 35 648 375 35648.375 Number 35648375 35648.375

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

 Setting 1 Setting 2 String 35,648.00 35,648.00 Number 35648 35648

num( pi( ), '0,00' ) returns:

 Setting 1 Setting 2 String 3,14 003 Number 3.141592653 3.141592653
New Contributor II

## Re: I need to convert a number into a certain format text

Thanks!! Wouldn't of thought to use a num function!

New Contributor II

Thanks!!

MVP