Removing Decimal points from a column

[Sionos]

Hi all,

I have a set of reports that have durations in the columns. At present they are in the format 0.30 (30 seconds) but i need them shown as 0030. How do i do that?

Cheers.

[JONvdHeyden]

Do a find & replace on the column (CONTROL+H)
Find what: . [a dot]
Replace with: [leave blank]
Replace All

Then format the column with a custom number format 0000