I have a column of MGRS Grid Coordinates. These coordinates range from four digits to ten digits. I need to convert all four, six, and eight digit coordinates to ten digit but can't figure it out. Here are some examples:

Four Digit: 30 98 needs to read 30000 98000

Six Digit: 304 987 nees to read 30400 98700

Eight Digit: 4567 7898 needs to read 45670 78980

I need to convert these (by adding zeros) so I can use the data in crystal reports.

I can't do it manually as there are too many. Is there a way to automate this process?

Thank You