Functional Question

[wannafly]

Hello, I'm not an experienced excel user and I'm working on a .csv datasheet. My problem is that one of my columns has to have six digits of zero (000000) in every bracket, but excel automaticaly removes five of them and leaves only one (0). I'm sure there is a way to change that, I'm using excel 2007, but if someone knows the answer on another version can tell me as well. Please help.

 

[jberwald]

Format the column as Custom. Enter 000000# where you type in the custom format you want.

 

[wannafly]

Format the column as Custom. Enter 000000# where you type in the custom format you want.

Thanks a lot mate