Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Amount without "," or "."
Hello,
Is it possible to format a value i.e. 151821.75 in Excel to display as 000000015182175? The decimal places and comma need to be removed and the field length must always be 15 characters. For example the amount 258.73 will need to be displayed as 000000000025873. Thanks in advance for any help or advice. Regards, Brett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Amount without "," or "."
I don't think you can remove the decimal point. Instead you could multiply
the number by 100 in another column then use the following custom format #00000000000000 " wrote: Hello, Is it possible to format a value i.e. 151821.75 in Excel to display as 000000015182175? The decimal places and comma need to be removed and the field length must always be 15 characters. For example the amount 258.73 will need to be displayed as 000000000025873. Thanks in advance for any help or advice. Regards, Brett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Amount without "," or "."
On 26 Mar, 11:26, Joel wrote:
I don't think you can remove the decimal point. *Instead you could multiply the number by 100 in another column then use the following custom format #00000000000000 " wrote: Hello, Is it possible to format a value i.e. 151821.75 in Excel to display as 000000015182175? *The decimal places and comma need to be removed and the field length must always be 15 characters. *For example the amount 258.73 will need to be displayed as 000000000025873. Thanks in advance for any help or advice. Regards, Brett- Hide quoted text - - Show quoted text - Thank you, this is pefect. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |