cannot use zero value first in field

P

PeterAtherton

I assume that you want a number like 002345 in a cell.

The cell can be formatted as text and will acept this and display the text
on the left of the cell.

Alternatively, choose Format, Cell, Custom and in the custom textbox enter
something like 000000. 1234 will bedisplayed as 001234

Regards
Peter
 

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

Top