Hi
This might be a dumb question but its bothering me, I have an excel worksheet data feed file which I save as tab delimited before uploading to a site.
My problem is when I re-open this file the bar codes are not saved correctly, in the cell I have something like 1.23457E+11 but in edit bar I see 123456789123 ?
I keep losing this particular type of data, is it because I am not saving the file correctly?
Thanks
Peter
Peter
onwards and upwards
Select the column that you want to fix... and go to Format|Cells...
In the Number tab, select Number and change the decimal places to 0.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks