Importing into excel PROBLEMS

  • Thread starter Thread starter cameljs18
  • Start date Start date
C

cameljs18

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
 
Specifically, how are you importing the data........and from what type
source? Some methods allow the formatting to TEXT during the transition.

If possible, you may be able to put a leading Alpha character or two on the
numbers before importing and remove later.........

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting text into years 4
Help with Formatting Number as Text 5
Help Formating Numbers to Text 1
Formatting Numbes to Text 1
Formatting Numbers as Text!!! 4
Formatting Numbes as Text!!!! 1
counting items within a date range 1
IF calculation of Time 2

Back
Top