Adding comma to a custom type.

mcook · #1 08-11-2011, 12:22 PM

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?

Catalin.B · #2 08-13-2011, 03:08 AM

why dont you use a formula in another column to divide the numbers with 100, and just format the number to show separator for thousands to show your number as you wish?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding Image into a excel cell and adding a hyperlink to the image	saravananiyyanar	Excel	3	05-04-2011 08:31 AM
How do I get rid of this type of symbol	jerry1234	Word	1	09-04-2010 05:39 PM
adding a comma in end of each line in word	juanb007	Word	0	07-23-2010 01:28 PM
Word won't let me type t, c, h, v	laxation	Word	0	04-22-2010 12:51 AM
thousands comma separator	taylormayd	Excel	3	02-20-2009 03:46 AM