Hi kopo and welcome to the forum,

I believe your answer is hiding in Custom Number Formats. Read and study http://www.ozgrid.com/Excel/excel-cu...er-formats.htm