[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

fraction to text on excel

Posted on 2013-01-21
6
Medium Priority
?
371 Views
Last Modified: 2013-01-22
Hi all
i need to upload a large ammaunt of data to a database
but in some cases when convert to text a fraction 1 1/2   displays as  1.5, i convert it to text but in the addres bar displays in some cases the decimal format when i need all in fractional format, is any way to do so?
tsm
0
Comment
Question by:Ernesto
  • 3
  • 2
6 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38803701
Hello,

if you need to convert the numbers into text, then you can use a formula like this:

=TEXT(A1,"# ?/?")

copy the result and paste special > values to get the text value instead of the formula.

cheers, teylyn
0
 
LVL 7

Expert Comment

by:jaynee
ID: 38803761
You are putting this large amount of data into an excel spreadsheet, not a database, right?  What version of excel, and how are you getting it in? eg Excel 2007 using the menu item Data/From Text ?
0
 

Author Comment

by:Ernesto
ID: 38803908
Yes thats the case, even when i format all in text and pase only values in some cells in the addres bar shows as example 5.5  besides 5 1/2 that was the original value input, and when im exporting to the db exports 5.5  is exel 2007 but the file is saved as excel 2003 because the engine that i deploy in vb needs that version
Please help in here!!!
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:Ernesto
ID: 38803918
think got it with your solution teylyn
0
 
LVL 7

Expert Comment

by:jaynee
ID: 38804117
I'm glad to hear it.
0
 

Author Closing Comment

by:Ernesto
ID: 38806219
tsm,
regards
edo
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question