Select one of the cells.
Look at the formulabar.
If you see the spaces, then select that column and use:
Edit|replace
what: (space character)
with: (leave blank)
replace all
And give that column the number format you like.
If you don't see the spaces, then try reformatting the range.
Select the column
Format|Cells|number tab|Custom
type:
0000000000
Hi,
Highlight the column, press CTRL H, Find what enter and space, don't enter
anything in replace with, hit replace all
if this helps please click yes, thanks
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.