How to Covert Dimension values format

[kunkumnaveen]

Hello All,

I have got a Dimension( Number) and the values are like 

Number

900000

1000000

1100000

1200000

 .....and So on

so how to achieve in below format

Require Out Put

Number

9Lak

10Lak

11Lak

12Lak

....so on

Thanks

[jonathandienst]

Many ways to do this, variations on 

= Floor(Number / 100000, 0) & 'Lak'

 Ceil, Round, Num() are all alternatives.