#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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?
|
|
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 |