How to remove point from crystal report

Question

I have a number, for example I have 1234.73 when I export report to excel I only get 000001234 and I need to get 000123473 how can I do that

There is my Crystal Report Formula:

totext({Myfield},'000000000')

Answer 1

use this:

right('000000000'+replace(totext({Myfield}),'.',''),9)