How to find same amount of charachters from string with special charachters and different lenght

[yomero]

Hi how can i get the same amount of left characters from values regardless if they have a "minus" sign at the beginning

Example
-114.3583 = -114.35
-41.89737 = -41.89
23.2321112 = 23.23

 

[FDibbins]

If you only want to see 2 decimal places - without actually changing the cell value, just set the format to only show 2 decimal places.

If you want to actually CHANGE the value, the maybe this?

	A​	B​	C​
1​	-114.3583	-114.35	-114.35​
2​	-41.89737	-41.89	-41.89​
3​	23.2321112​	23.23​	23.23​

C1=ROUNDDOWN(A1,2)

 

[yomero]

My fields are stored as Strings, not numbers

If you only want to see 2 decimal places - without actually changing the cell value, just set the format to only show 2 decimal places.

If you want to actually CHANGE the value, the maybe this?

	A​	B​	C​
1​	-114.3583	-114.35	-114.35​
2​	-41.89737	-41.89	-41.89​
3​	23.2321112​	23.23​	23.23​

<tbody>
</tbody>

C1=ROUNDDOWN(A1,2)

 

[yomero]

Got it
Expr1: IIf(IsNull([lon]),"",Round(Val([lon]),3))

Thanks!

 

[FDibbins]

OK, same example...
C1=LEFT(A1,FIND(".",A1,1)+2)
copied down

edit: My apologies, just noticed this is in teh Access section, not Excel