Display Amount without "," or "."

  • Thread starter Thread starter brettmanning24
  • Start date Start date
B

brettmanning24

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
 
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
 
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







- Show quoted text -
Click to expand...

Thank you, this is pefect.
 
Back
Top