"'Mike'" wrote in message
...
"David (Normandy)" wrote in message
...
"'Mike'" wrote in message
...
"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
Mike, if you want to display 'numbers' that have leading zeros then they
are not actually numbers they are text. Numbers are something you can do
calculations on - add up, multiply etc. I don't think you want to do any
calculations with these?
1. Select the entire column (click the column letter at the top to
highlight the entire column).
2. Click Format Cells
3. Click the Number tab
4. Click the category 'text'
Job done. You can type the numbers in without having to type a single
quote in front of each one.
David.
No calculations David. Just numbers which have to be put in numerical
order. :-))
Many thanks
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
Mike,
Thi gets back to what I said at 09:50, comming from Church before i got into
agricultural mode, and a lot of water has gone undre the bridge since then.
Your own response to Adrian corssed mine in the ether, o it may have been
missed;
If you dont want to do any numerical operations, you would be better off
with a table in Word, but it appears you need to sort these, which is a
numerical operation, and so needs numbers.
You can format numbers all to have the same string length before the decimal
point, that is have leading zeros, as i aid before by:
Format cells (by right click or the menu bar), this gives a multi tabbed
window, one of the tabs is "Number", choose this.
Now scroll down to "Custom", and it the "type" put:
000
or 0000.000, or whatever you need.
You can probably put blank between the groups of three didgit as well, in
the custom format window, i suggest you look at the help files.
There i an Excel newsgroup, i havent looked at it for years, but it is
probably way above what you are trying to achieve here.
I hope your RNEBA reunion goes well!
John