custom formatting

[lezawang]

Hi
I want to write a custom formatting code to do the following:

[TABLE="class: outer_border, width: 300"]
<tbody>[TR]
[TD]user enter[/TD]
[TD]excel shows[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]1 k[/TD]
[/TR]
[TR]
[TD]1245[/TD]
[TD]1.245 k[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]55[/TD]
[/TR]
</tbody>[/TABLE]

Is that possible? Thank you very much

 

[Rick Rothstein]

If you won't mind exact number of kilos (e.g., 8000) displaying with a trailing decimal point (i.e., 8. k), then you can use this custom format...

[>=1000]0.####, k

where you would put as many # signs as maximum decimal places you are willing to display.

If you would not mind trailing zeros (e.g., 8.000 k), you could use this instead...

[>=1000]0.000, k

where you put put as may zeros after the decimal point as the maximum number of decimal places you want to always display.

 

[Artik]

Experiment with the following format

[>=1000]#.##0," k";[<=-1000]-#.##0," k";#,##0.###

..::Edit Eh, I didn't see Rick's post ::..

Artik