Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
OT OT Excel ??????
"'Mike'" wrote in message
... "Adrian" wrote in message ... Hi Mike On Sun, 29 Jul 2007 09:24:00 +0100, "'Mike'" wrote: 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? At a guess (don't have time this morning to 'play' !) - but right-click the cell and select 'format cells' (on my very elderly copy of Excel). There should be an option there that will do what you want - maybe 'text' - you need to convince Excel that it deosn't need to remove the leading zero... Hope this helps Adrian Mike BRILLIANT!!!! Very many thanks to both of you. It works ;-)) I have a load of data which I can now add to and write a book, the data of which can be transposed into many different tabular ways before going to the printers :-)) Thanks again 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 I might be a bit late, but here i my two pennyworth. 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. Now back to my industrial scale weeding following the rain! Cheers John |
Reply |
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 |