Microsoft Office Forums - View Single Post - Adding comma to a custom type.

Thread: Adding comma to a custom type.

View Single Post

Old

08-11-2011, 12:22 PM

mcook

mcook is offline

mcook uses Windows 7 64bit

Windows 7 64bit mcook uses Office 2010 32bit

mcook uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Aug 2011

Posts: 1

mcook is on a distinguished road

Default

Adding comma to a custom type.

I am using excel 2010 and having a problem figuring this out. I have a number like 123456, i needed to add a decimal in front of the last 2 digits. I used #"."#0 in the Custom types, now i need to add the comma so the number shows as 1,234.56. Can anyone help?

Reply With Quote