"®óñ© © ²°¹°-°³" wrote in message
...
On Sun, 29 Jul 2007 17:16:17 +0200, "David \(Normandy\)"
wrote and included this (or some of this):


"Frank Booth Snr" wrote in message
.. .
®óñ© © ²°¹°-°³ wrote:

On Sun, 29 Jul 2007 09:24:00 +0100, "'Mike'" wrote
and included this (or some of this):


I wish to put numbers in a cell which commence with a '0'. For example
067
but when I go to the next cell, the number reverts to just 67.

I can get over it by putting an 'O' (capital o), but this then does not
Data Sort properly.

Can anyone help please?


'067 will show as 067.

It will however be text, not a number.

As the guy said you simply type a single apostrophe before the number
you
wish to format as text. Eg '456.88. No need to bother with format menus.

Strongly disagree. The problems with just using a single apostrophe to
force
numbers to be text occur when you try to sort the column. Things end up in
the wrong place as you are mixing numbers and text. It can also lead to
computational errors depending on how complex the spreadsheet is.

So don't try to use numbers and text in the same column.

If Mike wants to sort a text column, he inputs a text column and
nothing else. And he keeps numbers in a separate column.

What's the problem?


Hopefully none :-)

Text will be in one column, followed by a column of numbers which include
this wretched 0 at the beginning of 'some' numbers, then other columns with
text.

Thanks for your help and interest ;-)

Mike


--
The Royal Naval Electrical Branch Association.
'THE' Association if you served in the Electrical Branch of the Royal Navy
Reunion Bournemouth August/September 2007
www.rneba.org.uk
"Navy Days" Portsmouth 25th - 27th July 2008. RN Shipmates will have a Stand