Number format: 12.34 to 00001234

[Guest]

i need to change a number as detailed in the header. I can multiply out the
decimal place but am at a loss as to how to append zeros to the srat, it is
complicated as some numbers may be 123.45 so need less zeros appending. The
resultant file will be exported as a text felt to be processed in DB2

any help very welcome, thanks

 

[Guest]

Pete,
Try a new field where the record source (or expression in a query) is
Format([TheNumber],"00000000")

Add as many zeros as you need. Also, you can use the formula to remove the
decimals in the same line like:
Format(Int([TheNumber]*100),"00000000")

Hope this helps.