format number...

[sal21]

i can have a number:

42,3
41,8919
28,478
...

ho to update and have a new format:

42,3000
41,8919
28,4780

Tks.

note:
- the value are string format, MyNum as string
- i need a 4 decimal

[HansV]

Is it a number field or a text field?

And is the comma the decimal separator?

[sal21]

Is it a number field or a text field?

And is the comma the decimal separator?

modified my old post, sorry for delay

And is the comma the decimal separator?, yes

[HansV]

Have you tried Format(MyNum, "0.0000") ?

[CData]

it could be implemented at the table level, or at the control at presentation level (form/report). use 'fixed' and then specify 4 digit decimal

[sal21]

Have you tried Format(MyNum, "0.0000") ?

GREAT!

[sal21]

Is it a number field or a text field?

And is the comma the decimal separator?

Still on..

now myvar is dimensioned As String and the separator is a dot.

i now i can have:

40.663455
16.610637
40.663455
6.61
40.663301
16.610702
40.663294
16.61071
40.648544

i need:
40.663455
16.610637
40.663455
6.610000
40.663301
16.610702
40.663294
16.610710
40.648544

[HansV]

Try

Format(Replace(myvar, ".", ","), "0.0000")