If i had a long column of weights for eg: 60 Kg 35 Kg 75 Kg 59 Kg and so on. is there any way of making the cells only show the number, so i could copy and past the numbers to Access into data bank...
a sum for using on excel to convert say for eg! number 6.35 into 6min 35sec number 1.30 into 1min 30sec number 5.59 into 5min 59sec & so on. obviously 5.75 cant be used. the whole number is...
Is it possibel to colour code Document titles, Say if you had a file with accounts & personnal information the names of accounts were coloured red & personnal were blue.
using Excel if i had dates of birth in one column eg 26/12/1959 what equasion / sum would i need to put in the next column to give me the age eg 45yrs (it would need to update itself automatically....
