CODEWITHSUNDEEP
excel
Bill Reilly
Bill Reilly

Reputation: 63

How to add leading zeros to a field in excel

I have a currency amount that for example is 11.20

I need it to be 11 characters not including the '(see below), with leading 0's to fill the characters.

I need 4 characters to the right of the decimal, and it needs to have a ' on the end so my end value needs to be:

00000112000'

I have tried multiple formulas and for some reason can't figure this out as basic as it might seem.

Upvotes: 0

Views: 10529

Answers (1)

Eugene Sh.
Eugene Sh.

Reputation: 18331

Go to "Format Cells". In "Number" tab select "Custom". And type in "Type" as many zeros as you need:

enter image description here

Upvotes: 3

Related Questions