Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Getting Started > Data stored as ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 16843 of 17534
Post > Topic >>

Data stored as text convert to values

by "Leo Rod" <leo@[EMAIL PROTECTED] > Aug 1, 2008 at 02:02 PM

Good afternoon,

I have a column in a set of data formatted as text; is there any way to 
convert this information to values? They're all numbers ending with ".0000

"-
No decimal values are into this data column.

I try eliminating the ".0000  " from all the values replacing it by "" but

it still text and I cannot make any operations with it.

Can I add a calculated column with the same set of data into values like
in 
excel with the function "Values()"??

Please let me know if you guys can think of any other solution for this 
predicament.

Respectfully,

Leo-MIA, FL
 




 3 Posts in Topic:
Data stored as text convert to values
"Leo Rod" <l  2008-08-01 14:02:48 
RE: Data stored as text convert to values
=?Utf-8?B?S0FSTCBERVdFWQ=  2008-08-01 12:37:01 
Re: Data stored as text convert to values
"Leo Rod" <l  2008-08-04 16:09:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 16:38:51 CST 2008.