I have to enter a EE number in a cell, and I have to make it 10 characters long which means I have to add 3 zeros at the beginning of the EE number. Is there a way to format the cells so it does this automatically??
I have to enter a EE number in a cell, and I have to make it 10 characters long which means I have to add 3 zeros at the beginning of the EE number. Is there a way to format the cells so it does this automatically??
You can custom-format the cell as 0000000000 which will make it appear to have 10 digits.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks