Number Formating

[TwinHype]

Hi All,

I'm new and have a question:

I would like to display the following number 2,550,567 as 2,550 (K)

Does anyone know how to apply this custom format

Thanks in advance

Twin

 

[raskew]

Hi -

Try (from the debug window):

x = 2550567
y = format(x\1000, "#,###(K)")
? y
2,550(K)

HTH - Bob

 

[TwinHype]

Debug Window? apologies but i'm not what you'd call a super user!!

 

[raskew]

Also called the Immediate window.

If using A97, press Cntl-G to display the window. In later versions, open any standard module. The immediate window should appear simultaneously.