Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
Hi, is there a way to custom format a cell, to read millions (all numbers) to
same as divided by 1 million, with 1 decimal after the period? thanks... i.e.: 25,052,000 will read 25.1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
You could try making a source cell with the original number and enter a
formula to divide by 1,000,000. And then go to formatcellsnumber decimal places 1. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
Hi,
Go to Format cells, Custom format and enter #,,.0 Regards Govind. nastech wrote: Hi, is there a way to custom format a cell, to read millions (all numbers) to same as divided by 1 million, with 1 decimal after the period? thanks... i.e.: 25,052,000 will read 25.1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
Govind,
Do the commas represent the number of digits before the decimal point? So if the number was 100,000,000 would it still display properly or would you change the format to #,,,.0 Thanks, Susu "Govind" wrote: Hi, Go to Format cells, Custom format and enter #,,.0 Regards Govind. nastech wrote: Hi, is there a way to custom format a cell, to read millions (all numbers) to same as divided by 1 million, with 1 decimal after the period? thanks... i.e.: 25,052,000 will read 25.1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
tried it thanks, think comma's represent triple zero places / 1000x, looks
like: if you didn't catch it: #,,.0 (# comma comma period zero) "susubee" wrote: Govind, Do the commas represent the number of digits before the decimal point? So if the number was 100,000,000 would it still display properly or would you change the format to #,,,.0 Thanks, Susu "Govind" wrote: Hi, Go to Format cells, Custom format and enter #,,.0 Regards Govind. nastech wrote: Hi, is there a way to custom format a cell, to read millions (all numbers) to same as divided by 1 million, with 1 decimal after the period? thanks... i.e.: 25,052,000 will read 25.1 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
Hi,
Each comma represents a 000. Govind nastech wrote: tried it thanks, think comma's represent triple zero places / 1000x, looks like: if you didn't catch it: #,,.0 (# comma comma period zero) "susubee" wrote: Govind, Do the commas represent the number of digits before the decimal point? So if the number was 100,000,000 would it still display properly or would you change the format to #,,,.0 Thanks, Susu "Govind" wrote: Hi, Go to Format cells, Custom format and enter #,,.0 Regards Govind. nastech wrote: Hi, is there a way to custom format a cell, to read millions (all numbers) to same as divided by 1 million, with 1 decimal after the period? thanks... i.e.: 25,052,000 will read 25.1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make custom formatting permanent | Excel Worksheet Functions | |||
Custom Formatting for Dates | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) | |||
Custom formatting | Excel Discussion (Misc queries) |