The cell is where it should show. In the formula only the number itself
should show.

--


Regards,


Peo Sjoblom

"Margy" wrote in message
...
When I type a value (e.g. 35) into the cell with custom format 000 " tons"
is
shows 000 tons in the cell and 35 in the formula bar. Very puzzling as I
have
been doing this for years on all versions of Excel - even 2007 and it is
only
my new notebook and DEesktop with Vista that is giving this problem - that
is
why I thought it might be related to Vista.
--
Margy


"Peo Sjoblom" wrote:

Have you tried?

000 " tons"


which should be the correct way of doing it on any version and on any OS

--


Regards,


Peo Sjoblom

"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

It needs to show 35 Tons in the cell not 000 tons in cell and 35 in formula
bar - which is what it is doing. If I custom it word first and then zeros it
is fine - it will show e.g. Tons 35 in cell and 35 in formula bar - which is
what it is suppose to do. Very puzzled.
--
Margy


"Peo Sjoblom" wrote:

The cell is where it should show. In the formula only the number itself
should show.

--


Regards,


Peo Sjoblom

"Margy" wrote in message
...
When I type a value (e.g. 35) into the cell with custom format 000 " tons"
is
shows 000 tons in the cell and 35 in the formula bar. Very puzzling as I
have
been doing this for years on all versions of Excel - even 2007 and it is
only
my new notebook and DEesktop with Vista that is giving this problem - that
is
why I thought it might be related to Vista.
--
Margy


"Peo Sjoblom" wrote:

Have you tried?

000 " tons"


which should be the correct way of doing it on any version and on any OS

--


Regards,


Peo Sjoblom

"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

Just humour us & check your custom formatting again, particularly the
position of the quote marks. You would get the symptoms you describe if
your custom formatting says "000 tons" instead of 000 " tons"
--
David Biddulph

"Margy" wrote in message
...
It needs to show 35 Tons in the cell not 000 tons in cell and 35 in
formula
bar - which is what it is doing. If I custom it word first and then zeros
it
is fine - it will show e.g. Tons 35 in cell and 35 in formula bar - which
is
what it is suppose to do. Very puzzled.
--
Margy


"Peo Sjoblom" wrote:

The cell is where it should show. In the formula only the number itself
should show.

--


Regards,


Peo Sjoblom

"Margy" wrote in message
...
When I type a value (e.g. 35) into the cell with custom format 000 "
tons"
is
shows 000 tons in the cell and 35 in the formula bar. Very puzzling as
I
have
been doing this for years on all versions of Excel - even 2007 and it
is
only
my new notebook and DEesktop with Vista that is giving this problem -
that
is
why I thought it might be related to Vista.
--
Margy


"Peo Sjoblom" wrote:

Have you tried?

000 " tons"


which should be the correct way of doing it on any version and on any
OS

--


Regards,


Peo Sjoblom

"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

I do have only the word in inverted commas - not the zeros as per your exampe
000 " tons". I promise I am not being "blonde"

Your assistance is really so much appreciated.
--
Margy


"David Biddulph" wrote:

Just humour us & check your custom formatting again, particularly the
position of the quote marks. You would get the symptoms you describe if
your custom formatting says "000 tons" instead of 000 " tons"
--
David Biddulph

"Margy" wrote in message
...
It needs to show 35 Tons in the cell not 000 tons in cell and 35 in
formula
bar - which is what it is doing. If I custom it word first and then zeros
it
is fine - it will show e.g. Tons 35 in cell and 35 in formula bar - which
is
what it is suppose to do. Very puzzled.
--
Margy


"Peo Sjoblom" wrote:

The cell is where it should show. In the formula only the number itself
should show.

--


Regards,


Peo Sjoblom

"Margy" wrote in message
...
When I type a value (e.g. 35) into the cell with custom format 000 "
tons"
is
shows 000 tons in the cell and 35 in the formula bar. Very puzzling as
I
have
been doing this for years on all versions of Excel - even 2007 and it
is
only
my new notebook and DEesktop with Vista that is giving this problem -
that
is
why I thought it might be related to Vista.
--
Margy


"Peo Sjoblom" wrote:

Have you tried?

000 " tons"


which should be the correct way of doing it on any version and on any
OS

--


Regards,


Peo Sjoblom

"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

Sorry for the typo - I meant inverted commas. I am entering 000 "tons" and
the result is 000 tons in cell. If I customise "tons" 000 that works
perfectly.
--
Margy


"David Biddulph" wrote:

Just humour us & check your custom formatting again, particularly the
position of the quote marks. You would get the symptoms you describe if
your custom formatting says "000 tons" instead of 000 " tons"
--
David Biddulph

"Margy" wrote in message
...
It needs to show 35 Tons in the cell not 000 tons in cell and 35 in
formula
bar - which is what it is doing. If I custom it word first and then zeros
it
is fine - it will show e.g. Tons 35 in cell and 35 in formula bar - which
is
what it is suppose to do. Very puzzled.
--
Margy


"Peo Sjoblom" wrote:

The cell is where it should show. In the formula only the number itself
should show.

--


Regards,


Peo Sjoblom

"Margy" wrote in message
...
When I type a value (e.g. 35) into the cell with custom format 000 "
tons"
is
shows 000 tons in the cell and 35 in the formula bar. Very puzzling as
I
have
been doing this for years on all versions of Excel - even 2007 and it
is
only
my new notebook and DEesktop with Vista that is giving this problem -
that
is
why I thought it might be related to Vista.
--
Margy


"Peo Sjoblom" wrote:

Have you tried?

000 " tons"


which should be the correct way of doing it on any version and on any
OS

--


Regards,


Peo Sjoblom

"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