I have an csv file that has a column of numbers in the form ab:cd:ef:ghy The cell's number format is general, I want to be able (if other criteria are met) to change y into y+1. The final column must again have the form ab:cd:ef:ghy and the number format general, can anyone out there give me an idea how to manipulate numbers in this format.(adsbygoogle = window.adsbygoogle || []).push({});

**Physics Forums | Science Articles, Homework Help, Discussion**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# EXCEL General number format

**Physics Forums | Science Articles, Homework Help, Discussion**