Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-29-2009, 06:44 AM
ali_c_uk ali_c_uk is offline Windows XP Office 2003 (Version 11.0)
Novice
 
Join Date: Nov 2009
Posts: 1
ali_c_uk is on a distinguished road
Default Inserting Fractions

On my laptop I can use Fn+Alt+171 to insert ½, 172 for ¼ and 0190 for ¾. Does anybody know how to do the same for 1/8, 3/8, 5/8 and 7/8? I have seen codes for them 215B, 215C, 215D and 215E but they don't seem to work in the same way. I am sure there is a simple explanation to this issue!
Reply With Quote
  #2  
Old 11-29-2009, 08:38 AM
zyzzyva57 zyzzyva57 is offline Windows Vista Office 2007 (Version 12.0)
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 381
zyzzyva57 is on a distinguished road
Default

You can simply in a cell enter zero ("0") followed by a space and then a fraction, e,g, 0 1/2 or 0 1/8 and then hit Enter

Otherwise, 1/8 becomes a date and NOT shown as a fraction

The way I have shown you can be used as a math formula, e.g.,

1/2 + 1/2 summed becomes 1
Reply With Quote
  #3  
Old 01-17-2010, 10:26 AM
BjornS BjornS is offline Windows Vista Office 2003 (Version 11.0)
Advanced Beginner
 
Join Date: Jan 2010
Location: Sweden
Posts: 71
BjornS is on a distinguished road
Default

Hi, did this solve your issue?

If NO, please comment.
If YES, please mark it as solved, see this link: http://www.msofficeforums.com/excel/announcements.html

Marking issues as solved makes this forum more effective!

Best regards
Bjorn
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting border above the text bishke Word 1 11-17-2009 12:25 PM
Inserting images into mail merge lorraine_hamilton Mail Merge 0 10-19-2009 12:55 PM
Newbie - Need help with inserting charts into slide using VBA fretwizard PowerPoint 1 06-23-2009 11:45 AM
Inserting one office document into another, reads changes darkproject2 Word 4 06-18-2009 02:35 AM
Inserting paragraph into template option kristinepjones Word 1 04-12-2009 08:21 AM


All times are GMT -4. The time now is 04:20 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.