Hi Margy

Are you sure you type Zeros in the format, and not text O's?

--
Regards
Roger Govier

"Margy" wrote in message
...
Sorry Roger should have told you what happened.

If I customized 000 "tons" - when I type a value e.g. 35 into the cell it
will read 000tons and does not show e.g. 35 tons - that is only on the
Vista
PCs.
--
Margy


"Roger Govier" wrote:

Hi Margy

When you say it does not work, what happens? What do you see in the cell.
Works perfectly for me on Vista Business and XL2007

--
Regards
Roger Govier

"Margy" wrote in message
...
Format Cell - Number Tab - Category Customer. If we put in e.g. "Inv"
000
and
cells will read Inv 014 etc. If we do 00 "Kg" (i.e. after the 00) would
read
14 Kg etc. This has always worked on any computer running Excel 2007 on
Windows XP. On both our computers running on Vista Busines if we custom
the
number "Inv" 000 - no matter what we put in front of the number - it
works -
but it will not work when we put the word after the number i.e. 00
"Kg"
Assistance will be much appreciated.
--
Margy
Pinetown, South Africa