How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask michelleclive Your Own Question

michelleclive
michelleclive, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 4667
Experience:  Indept expertise on MS Office package
26798893
Type Your Microsoft Office Question Here...
michelleclive is online now

A recent problem with Excel. If I type e.g. '12.00

Customer Question

A recent problem with Excel. If I type e.g. '12.00 the 2 disappears and I get 1.00. This applies every time the 2 follows the number 1.
Also when typing upper case A it changes to lower case a, I cannot find a way to correct either problem.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  michelleclive replied 1 year ago.
michelleclive :

Hi, My name is ***** ***** i will be assisting you

michelleclive :

please let me know does this problem occur only in excel or other programs as well like word, notepad, email etc

JACUSTOMER-fby9xjlx- :

Only in Excel

michelleclive :

ok

michelleclive :

please let me know whether you are using xp, vista, windows 7 or 8

JACUSTOMER-fby9xjlx- :

I am using xp on a Mac OS X 10.6.8

michelleclive :

ok

michelleclive :

please check the below

michelleclive :

  1. Click Start, point to Settings, and then click Control Panel.

  2. Double-click Regional and Language Options.

  3. Click the Languages tab.

  4. In the Text Services and Input languages pane, click Details.

  5. In the Installed Services pane, click any keyboard listed other than US, and then click Remove.

  6. When the confirmation message appears, click Yes.

  7. Repeat step 5 until all listed keyboards except US are removed.

michelleclive :

then check in excel if problem repeats or goes off

JACUSTOMER-fby9xjlx- :

Mac OS X 10.6.8 I can't find settings on my Mac only

JACUSTOMER-fby9xjlx- :

NoSettings or Language options, only system preferences

michelleclive :

in xp mode you need to follow these steps

JACUSTOMER-fby9xjlx- :

I am not sure what xp mode means I use Excel.xls

michelleclive :

ok

michelleclive :

is this happening in a specific excel workbook or on any excel file you open

JACUSTOMER-fby9xjlx- :

any excel file I open and start typing

michelleclive :

try this

michelleclive :

System preferences, keyboard, shortcuts and un-select ''the way Tab moves focus"

JACUSTOMER-fby9xjlx- :

I get to Shortcuts but there is no un-select " the way Tab moves focus."

michelleclive :

ok

michelleclive :

what is the version of excel you are using

JACUSTOMER-fby9xjlx- :

Microsoft Excel for Mac Service release 1

michelleclive :

ok

michelleclive :

go to Preferences/Edit and uncheck Cut, Copy and Sort objects with cells

JACUSTOMER-fby9xjlx- :

I have no more time, Doctors appointment, I will have to try and solve problem myself. Please cancel £20 fee

JACUSTOMER-fby9xjlx- :

0

michelleclive :

no issues..iwill opt out and report it for a refund

JACUSTOMER-fby9xjlx- :

Michelle ended chat and said she would organise a refund of £20.

JACUSTOMER-fby9xjlx- :

I have to go now , Michelle has promised to organise refund of £20. Will sort myself with local expert.

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    232
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg KamilAnwar1's Avatar

    KamilAnwar1

    Office Specialist

    Satisfied Customers:

    118
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    111
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    110
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/SH/Shefin/2012-6-6_17328_1.64x64.jpg Shefin's Avatar

    Shefin

    Microsoft Office Specialist

    Satisfied Customers:

    55
    Working as Tech support specialist with a world famous computer manufacturer
 
 
 

Related Microsoft Office Questions