Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.



19 posts

Geek


Topic # 106271 20-Jul-2012 14:37 Send private message

Thinking I was being very smart, I made an Autocorrect rule to convert 1.5 into a mixed number (integer + fraction) in a Word Document. It worked perfectly - however, now when I enter 1.5 in an Excel Document, the format changes in the same way and the number isn't recognised in formulas. What is the best way around this? (If it helps, the original requirement is just for one template - it doesn't have to be in Normal.dotx, but I didn't notice an obvious way of stipulating this).

Create new topic
356 posts

Ultimate Geek


  Reply # 667975 5-Aug-2012 21:48 Send private message





Hu? did i do that?
16Mb (EDO RAM), K6-II processor, 2Mb of onboard graphics. 32k dial up modem. 12 speed CD ROM. 5¼-inch floppy drive. 500Mb HDD.



19 posts

Geek


  Reply # 668389 6-Aug-2012 15:39 Send private message

Thanks for your suggestion. I've been using a workaround which solves my issue satisfactorily (when I want to enter 11/2 in Word I enter a couple of text characters using Autocorrect, leaving 1.5 free for Excel)

Create new topic
Twitter »
Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when new jobs are posted to our jobs board:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:




News »

Trending now »
Hot discussions in our forums right now:

Fecked up religious people strike again :-(
Created by Mark, last reply by nicnzl on 23-May-2013 16:41 (42 replies)
Pages... 2 3


Entire house HTPC concept
Created by InfiniteLoop, last reply by kiwijunglist on 23-May-2013 23:15 (25 replies)
Pages... 2


Cannabis is illegal yet we have really strong 'legal highs' ?
Created by qwerty7, last reply by freitasm on 23-May-2013 23:20 (74 replies)
Pages... 3 4 5


Xbox One
Created by DjShadow, last reply by jtbthatsme on 24-May-2013 01:04 (58 replies)
Pages... 2 3 4


Truenet Article - VoIP in New Zealand ----- Based on what Mr Butt ???
Created by maverick, last reply by Foiler on 23-May-2013 23:23 (18 replies)
Pages... 2


A new project coming to Geekzone
Created by freitasm, last reply by hamish225 on 23-May-2013 19:14 (278 replies)
Pages... 17 18 19


HTC One (2013) owners' discussion
Created by Dingbatt, last reply by bradstewart on 24-May-2013 00:53 (1546 replies)
Pages... 102 103 104


"igov" online passport renewals
Created by Linuxluver, last reply by profrink on 22-May-2013 22:22 (29 replies)
Pages... 2



Geekzone Jobs »
Most recent NZ jobs in technology:

Systems Analyst - mix BA, design & infrastructure
Posted 23-May-2013 22:28

Network Engineer - Urgent Requirement
Posted 23-May-2013 22:28

Senior Java developer - Contract Role
Posted 23-May-2013 22:28

Enterprise Architect
Posted 23-May-2013 22:28

Computer Programmer
Posted 23-May-2013 21:28

Software Developer - Queenstown
Posted 23-May-2013 19:28

Network Performance Engineer
Posted 23-May-2013 19:28


Geekzone Live »
Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.