Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formating numbers
I have a column of numbers, I want to format the numbers in a different
column using two different custom formats. Do i need an IF formula that will Identify which number chooses which format if so what would it be . i.e 6,500,000 = 6500 839,153 = 839153. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formating numbers
As long as the break point is consistent (ie, 1,000,000), you can do it with
a custom format, as in: [<1000000]0;[=1000000]0, Regards, Fred. "JK" wrote in message ... I have a column of numbers, I want to format the numbers in a different column using two different custom formats. Do i need an IF formula that will Identify which number chooses which format if so what would it be . i.e 6,500,000 = 6500 839,153 = 839153. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formating Cells | Excel Worksheet Functions | |||
Custom formating of cells | Excel Worksheet Functions | |||
custom cell formating | Excel Worksheet Functions | |||
custom formating a cell | Excel Worksheet Functions | |||
Custom formating won't work | Excel Worksheet Functions |