Custom Excel Format

[Ollie Shotton]

hi i have a number lets just say 123456 and i want it to be separated like 12,34,56 rather than 123,456.

ideally i would like each group of 2 to be in a separate cell and if i put say 123 in it would automatically update the next cell by 1 and the current cell by 23.

however if this is not possible then i would like just one cell with the comers separating every 2 digits!

Thanks in advance!
Ollie =)

[brnedon bourne]

if you put a inputmask on it you could get it to separate like that, It's relatively easy in Access but excel , im not sure....google "excel input mask" :)