Home |
Search |
Today's Posts |
#3
|
|||
|
|||
OT OT Excel ??????
"'Mike'" wrote in message
... 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? 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 Robert Harvey has it right. Highlight the column that you wish to format, then select 'Format Cells' and then 'custom'. Then select the first in the list and change it in the little window under 'Type:' to 000 or 0000 or whatever, and there you are. Numbers will display with as many leading zeros as are not otherwise occupied, and you can perform the usual maths or sort functions on them. No need for apostrophes or text formatting or whatever. The format you've just created will also appear as a new format in the custom list for future use. -- Chris E-mail: christopher[dot]hogg[at]virgin[dot]net |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flourish Excel and Press. CO2.... Redundant? | Freshwater Aquaria Plants | |||
Using Flourish Excel instead of CO2 ... not that expensive ... | Freshwater Aquaria Plants | |||
Using Flourish Excel instead of CO2 ... not that expensive ... | Freshwater Aquaria Plants | |||
Flourish Excel and Press. CO2.... Redundant? | Freshwater Aquaria Plants | |||
Flourish Excel as carbon source | Freshwater Aquaria Plants |