You'll have to write this formula Jarek gave you in a new column and then
copy the formula down the length of your data set.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
"capxc" wrote:
Do I put this command in format cell?
How to copy down?
Sorry , I am not very techie.
Please give me some lights.
Sincerely,
--
capxc
"Jarek Kujawa" wrote:
="08FG55"&D1
then copy down