Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
OT OT Excel ??????
wrote in message ups.com... On 29 Jul, 09:24, "'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? All you need to do is create a custom format. Select the cells, then format-cells - Number - select Custom - then (for example) type in 000000 as a format. In this first instance, I have been able to highlight the complete column then format column as text. I then went down the column changing the O's to 0's :-)) and it worked :-) The webmaster on our site has done one way, but when I send the next load of data to go on the site, it will be in the new format :-)) Of course the data for the book will already be in the new format :-)) and any I add can be new :-) Thanks everyone for the help. 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 |
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 |