"David (Normandy)" wrote in message
...

"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.

David.


David in that column, there will only be numbers, no text and the 0 will be
operational at the beginning of the number, i.e. 067. Take that the column
will have for example 087, 001, 093, 43, 23, 77, etc, I feel that as there
is no text I will not have a problem .............. I hope :-))

Your comments 'before' I plough tooooooooo much in would be appreciated,
ALSO, what tests would you recommend to 'sort' my numbers given that Col 1
will be text, col 2 will be text, col 3 will be the numbers ..... as text to
pick up the 0, and the rest text as in names etc.? I would wish to produce
tables/lists in different sequences of Col 1, then col 3 numbers then other
cols as text OR dates.

Massive amount of info to be fed in and I don't wish to have to go through
it all again :-))

(I think I may have bitten off more than I can chew. Maybe that is why the
book has never been published!!!!)

Kind regards

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