Number Format

[forestview]

Hi All

I have a list of asset numbers 6 digit from 1 to 999999 is there any way to get excel to keep the zeros i.e. 000001 as it always defaults to 1

Thanks in advance

Forestrview Scotland 08:53

[Glenn Kennedy]

Custom format the cells to 000000 and it'll work.

[forestview]

Thanks Glen that did the trick

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

[Pete_UK]

Note that that does not change the underlying values - they are still numbers in the range from 1 to 999999, which just happen to look like they have leading zeros.

Pete