Putting spaces to the right of numbers

[Vexrm]

Hey folks,

Got a strange question. I have a random length number followed by spaces to pad it out to certain character length and tyring to figure out how to get that to show correctly in excel. I know I can just put in ??????? for the format to get spaces in front.

For example:

??? as the format 5 as what I enter gets SPACE SPACE 5

The problem is I need 5 SPACE SPACE.

Any ideas?

[DonkeyOte]

Do you mean

#__

(# followed by 2 underscores)

[alski]

Not sure what you mean - but you could use

in A2
=trim(B2)
This clears all the spaces from the front or end of the data.
copy and pate values into column B

Then append 2 spaces onto it:
In A2
=" "&B2

There are 2 spaces in the middle of the quotes!

then copy and paste values again!

[Vexrm]

Well for example if I enter in 10 I need there to be one space after the 10, but if I enter in 1 I need two spaces after the 1, and if I enter in 100 I need no spaces.