Quote:
Originally posted by guest1 Paul, you need to include text in your formula and copy that formula to all of your cells. e.g. in cell C8 I have entered 7425 I have formatted cell C8 to 6 0's (custom format) in cell C9 I have entered a number 12 (no custom formatting) in cell C10 I would normally have entered =C8*C9 and seen a result of 89100 Custom formatting cell C10 could produce 089100 with your leading zero's, but you could also use the following formula instead: =TEXT(C9*C8,"000000") Unfortunately that does turn the cell into text but you can still use that text in another formula e.g. =C10*1 = 89100 Merging into Word you will need to alter the field formatting withinthe word document - use F9 to reveal field codes |
Thanks Alan, interesting option but what I'm trying to do is make up a simple column (which I can do if there are no leading zeros) so that I have a production date say 030406, with 01 to 99 behind that to give me up to 99 batches per day. Then by using the first entry in the column say 03040601 I can put a simple formula in the next row down =that cell+1. This when copied and pasted into the required number of cells gives a simple chronological record, when the date changes by a day it's a simple matter of changing one cell and carrying on copying the +1 formula. Once I've saved the excel sheet I can use the info in all sorts of ways by merging to word documents. Labels, production test records, delivery notes etc.
Just tried amending to suit my application and by formatting all the cells as text it seems to be working.
Thanks again to all for the advice
[Edited on 10-5-2006 by Paul James]