Custom rounding in Display

[Chartist]

I'm working with different numbers which have 6-10 digits, I only want to concentrate on 4 digits of significance. That is, only want to view the left-most 4 digits of the number. The remaining digits should be hidden if they are after the decimal, and replaced with 0 if before.

For example:
123456789 should be displayed as 123400000
0.123456789 should be displayed as 0.1234
0.0001234567 should be displayed as 0.0001234


Instead of using a formula, is this possible using a custom display right in the cell?
Thanks!

 

[Dave Patton]

Quick thoughts with trial and error

Test202101.xlsm
	A	B	C
1
2	123456789	123400000	123400000
3	0.123456789	0.1234
4	0.000123457	0.0001234
1a

Cell Formulas
Range	Formula
C2	C2	=INT(A2/10^(LEN(A2)-4))*10^(LEN(A2)-4)
B2	B2	=INT(A2/100000)*100000
B3	B3	=INT(A3*10000)/10000
B4	B4	=INT(A4*10000000)/10000000