Need to pad with Zeros to the existing list of numbers in a column

D

dwaraka

I have some values in a spreadsheet and I would like to pad with zeros to the
right side. For Ex. 1224 should be converted as 01234
 
T

Trevor Shuttleworth

Format the number as Category: Custom and Type: 00000

It won't change the number, just the way it is displayed

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change margins around bullets in list 1
Excel does not accept text format! 0
How do i zero pad when using combination of text and numbers? 1
Word- Find and Replace 1
Keeping Leading Zeros; How Please ? 2
Autonumber field in Excel that behaves the same as Access 0
Calculate the median value before a specified list 0
Left Padding a Number? 1

Top