Carim:

I do not understand the steps to take to make this work. When I try to
use =VALUE(TRIM(A1)), I get the following error in cell B1 #VALUE!.

Thanks

Carim wrote:

Hi,

First use the formula :
=VALUE(TRIM(A1))
Then use Format Cells Number Custom to input your format #### #### ####
####

HTH
Cheers
Carim