[FAQ000139]How do I convert a cell’s value to a zero-filled value?

Q

I want to display a value in a zero-filled format with a certain number of digits, like "00001".

What should I do?

A

CELF allows you to convert to zero-filled numbers using cell value change

actions and functions.

For example, to convert the value entered in cell A1 to a zero-filled value such as "00001",

create an action set with the following actions and link cell A1

as the cell value change action.

"Set [=RIGHT(INDIRECT("A1")+100000,5)] in cell [A1]" action

For more information about the Change Cell Value action, please click here.

Run an action set when updating cell values (Basic)

Related keywords

Excel, User format