Custom Number Formula to Make Adding Mark "." (Dot) Between 2 Number

[muhammad susanto]

hi all...

i need your help to figure it out this problem use Custom Number Formula
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]entry
[/TH]
[TH]expected result[/TH]
[/TR]
</thead><tbody> [TR]
[TD]11[/TD]
[TD]1.1[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]2.3[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]4.1[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]3.2[/TD]
[/TR]
</tbody>[/TABLE]

any help greatly appreciated...

sst.

 

[tyija1995]

Are the entries always just 2 digits? If so then use this:
=CONCAT(LEFT(A2,1),".",RIGHT(A2,1))
Where A2 would be your entry number.

 

[Rick Rothstein]

hi all...

i need your help to figure it out this problem use Custom Number Formula
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]entry
[/TH]
[TH]expected result[/TH]
[/TR]
</thead><tbody> [TR]
[TD]11[/TD]
[TD]1.1[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]2.3[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]4.1[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]3.2[/TD]
[/TR]
</tbody>[/TABLE]

I think either of the following Custom Formatting type patterns should do what you want, your choice...

0\.0

or...

0"."0

 

[muhammad susanto]

hi thank but i can't see its working..

 

[muhammad susanto]

Hi ...you're really hero!!!