muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to creating Custom Format to typing Latitude & Longitude
like this :
case 1
(Latitude)
[TABLE="width: 500"]
<tbody>[TR]
[TD]data
[/TD]
[TD]desired result
[/TD]
[/TR]
[TR]
[TD]1679755
[/TD]
[TD]1.679755
[/TD]
[/TR]
[TR]
[TD]18632547
[/TD]
[TD]1.8632547
[/TD]
[/TR]
</tbody>[/TABLE]
case 2
(Longitude)
[TABLE="width: 500"]
<tbody>[TR]
[TD]data
[/TD]
[TD]desired result
[/TD]
[/TR]
[TR]
[TD]101429118
[/TD]
[TD]101.429118
[/TD]
[/TR]
[TR]
[TD]101419375
[/TD]
[TD]101.419375
[/TD]
[/TR]
</tbody>[/TABLE]
thank for your helping
.sst
how to creating Custom Format to typing Latitude & Longitude
like this :
case 1
(Latitude)
[TABLE="width: 500"]
<tbody>[TR]
[TD]data
[/TD]
[TD]desired result
[/TD]
[/TR]
[TR]
[TD]1679755
[/TD]
[TD]1.679755
[/TD]
[/TR]
[TR]
[TD]18632547
[/TD]
[TD]1.8632547
[/TD]
[/TR]
</tbody>[/TABLE]
case 2
(Longitude)
[TABLE="width: 500"]
<tbody>[TR]
[TD]data
[/TD]
[TD]desired result
[/TD]
[/TR]
[TR]
[TD]101429118
[/TD]
[TD]101.429118
[/TD]
[/TR]
[TR]
[TD]101419375
[/TD]
[TD]101.419375
[/TD]
[/TR]
</tbody>[/TABLE]
thank for your helping
.sst