Converting an MGRS Grid Coordinate

[brownie224]

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

[Rutgers_Excels]

Try this....(Assuming the data you want to add 0's to is in cell A1)

=A1&REPT(0,10-LEN(A1))

[brownie224]

A1: 33 33

With this formula it returns: 33 3300000

I need it to read: 33000 33000

Help!!!