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

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

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.