number format

[bam12]

is there a way to type a number in and it put it in the format you have set up

example type 123456789012
and it put it as 1234567.89012
and can have leading zeros as well

 

[Andrew Poulsom]

You can check Fixed decimal and choose the number of Places on the Edit tab of the Tools|Options dialog. Note that this is an application wide setting.

 

[bam12]

i dont want it to be application wide

 

[Andrew Poulsom]

Turn it on, enter your number(s) then turn it off.

 

[CharlesChuckieCharles]

is there a way to type a number in and it put it in the format you have set up

example type 123456789012
and it put it as 1234567.89012
and can have leading zeros as well

Couple of points if someone types in "12345" is that supposed to be 000012345.00000 or 00000000.12345 ?

leading zeroes are a cell format thing no problem but getting the number of decimal places on input... much harder

 

[bam12]

no here is better sample

081113012345 would be 0811130.12345

 

[Jonmo1]

Would it be sufficient to have a formula in an adjescent column?

Enter your value in A1, in B1 put
=REPLACE(A1,LEN(A1)-4,0,".")

 

[CharlesChuckieCharles]

no here is better sample

081113012345 would be 0811130.12345

My point being... would the Inputter have to know the format of the number they are about to enter

so 123456789 has to be input as 0001234.56789 ?