YES !!! That works .

Thanks,

Gary

"Rick Rothstein" wrote:

Use this...

Format(12, "@@@")

--
Rick (MVP - Excel)


"Gary" wrote in message
...
I am using Excel 2007.
Format (12,€�000€�) gives me 012
I want (12,€�??0€�) to be 12 with a leading space

Question mark doesnt seem to work in Excel 2007


.