Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text data type changed when exporting a report to Excel

Status
Not open for further replies.
qwerty70

qwerty70

Technical User
Dec 13, 2005
73
GB
Dear All,

In my report, I have a field called "txtRevNum". When I preview record, it read as "1A". However, once I exported my report to Excel, "1A" becomes "0.0417". I'm just wondering why my text data field suddenly changed to number.

Your help is highly appreciated.

regards,

qwerty70
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
250
TrekBiker
TrekBiker
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
561
hermanlaksko
hermanlaksko
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
613
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
243
caykamanj1966
caykamanj1966
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
612
BJZeak
BJZeak

Part and Inventory Search

Sponsor

Back
Top