Time problem

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

1st thanks for reading this... I give up and need help. I'm trying to
put in a colon (:) automatically in a colunm when I enter a number.

This is minutes
I put this number in A1 34
and want it to convert to :34

it doesn't have to be a time format, I just need the colon.

Thanks-a-bunch

Bobby
 
Thanks Andy, I got the colon : to show, now only if I can get the
numbers to show also, but I'll work on it. The numbers like 01 02
will show up in the title line as 1 2 but not 01 02 in the cells.
Bob

fix 1 problem and another 1 pops up...
 
Thanks Andy, what you showed me works but not the way I want it to
turn out. I'll keep plugging along, I think the end project is just
way too big for my skills. I learned things for you, thanks.

bob
 
Back
Top