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 |
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 |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com