View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cameljs18@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Importing into excel PROBLEMS

Please help i am importing lots of barcodes into excel they have an R
in front eg.R80255112 and excel automatically converts them to rands
eg.R 802,551,12 which is unsuitable.When i change it to text it cuts
out the R. I am also importing a datestamp which is meant to be
2008-01-08 12:40:49.827PM but it comes out
2008-01-08T12:40:49.827+02:00.Please any suggestions