problem when saving CSV file
Why the leading 0 (zero) is dropped when I save the excel file as CSV file? Is there a way not the leading zero not to be dropped. What should I do to keep the zero leading on it. Thanks a lot. |
"mhe" wrote in message ... Why the leading 0 (zero) is dropped when I save the excel file as CSV file? Is there a way not the leading zero not to be dropped. What should I do to keep the zero leading on it. Thanks a lot. What do you have in the cell where you want a leading 0 in the csv file? I guess you could try to format the cells as text, that may help. /Fredrik |
All times are GMT +1. The time now is 09:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com