By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,080 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Custom Excel Format

P: 12
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 =)
Jun 22 '11 #1

✓ answered by 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" :)

Share this Question
Share on Google+
1 Reply


P: 2
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" :)
Jul 20 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.