Cell formatting in Microsoft Excel?

March 24, 2011 at 10:34:44
Specs: Windows XP
Hi guys

I want to format a column in excel so that whenever I type anything, it should automatically ad a "mm" at the end of it, so if I type in 600, it should automatically change it to 600mm. Much like the currency thing, but with custom letters at the back?

Any ideas?

See More: Cell formatting in Microsoft Excel?

Report •

March 24, 2011 at 12:13:09
You can't use just "mm" it is reserved by Excel for Dates & Time,

You need to precede them with a back slash character,
A Custom Format of


Should give you any 1-6 digit number and append the letters MM after it.

You enter: 123456
You get: 123456MM



Report •

March 24, 2011 at 12:28:39
Awesome, works like a bomb!

Thank you very very much!

Report •
Related Solutions

Ask Question