ɹəuəllıʍ ʇɐb Posted October 20, 2011 Report Share Posted October 20, 2011 I have a text (txt) file that contains tab-separated data, and I need to convert that to an Excel doc. No problem, I can just open it with Excel, and depending on the version, it will perform the conversion upon opening. However...There are some columns that contains numbers (ISBN, to be exact), like 0099778815, 0804811199, 1880656310, etc. When the converted document opens, these numbers show with leading zeroes truncated (99778815, 804811199, 1880656310). It doesn't matter if I format the column as text; the leading zeroes do not show. Does anyone know how to get these leading zeroes to stay? Thank you! P.S. just in case you want to know why I need these leading zeroes; I need to compare (join) them with another Excel doc that has these numbers complete with the leading zeroes. Quote Link to comment Share on other sites More sharing options...
ɹəuəllıʍ ʇɐb Posted October 20, 2011 Author Report Share Posted October 20, 2011 Found it: Custom format, then specify the mask as 0000000000. I have googled before posting here, but the Custom format did not work. (It did not work because by mistake I specified the mask with only 8 zeroes instead of 10.) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.