Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel formatting problem


(!)

Neovoca's Avatar
Neovoca Neovoca is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Jul 2012
Experience: Intermediate
10-Jul-2012, 10:05 AM #1
Excel formatting problem
Hi,
For months I have put up with this! Whenever I enter a number in a cell it converts to a percentage e.g. 10 becomes 0.10
I've tried everything and am probably missing something simple! Any help appreciated - running office for mac 97-2004
Thanks
Neovoca's Avatar
Neovoca Neovoca is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Jul 2012
Experience: Intermediate
10-Jul-2012, 10:07 AM #2
Formatting problem with Excel
Hi,
For months I have put up with this! Whenever I enter a number in a cell it converts to a percentage e.g. 10 becomes 0.10
I've tried everything and am probably missing something simple! Any help appreciated - running office for mac 97-2004
Thanks
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
 
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
10-Jul-2012, 10:11 AM #3
Is this on a particular workbook or all workbooks, even new ones?

Never used a mac so maybe a little hit or miss with this.
When you rightclick the cell and format - what is the number formatting?
etaf's Avatar
etaf   (Wayne) etaf is online now
Computer Specs
Moderator with 52,535 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
10-Jul-2012, 10:38 AM #4
i have moved to business applications forum

can you load a spreadsheet with the problem and with dummy data
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
 
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
10-Jul-2012, 10:44 AM #5
Neovoca's Avatar
Neovoca Neovoca is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Jul 2012
Experience: Intermediate
10-Jul-2012, 10:55 AM #6
Is this OK?
https://docs.google.com/a/neovoca.co...wdGwtY0E#gid=0

or is there an attach button I can't see?

Thanks, Mat
PS sorry I seem to have this q in 2 threads!
Neovoca's Avatar
Neovoca Neovoca is offline
Computer Specs
Member with 4 posts.
THREAD STARTER
 
Join Date: Jul 2012
Experience: Intermediate
10-Jul-2012, 10:58 AM #7
just 2 decimal places...all appears normal when I do this
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
 
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
10-Jul-2012, 11:01 AM #8
I get to the neovoca Ltd login page so i'm guessing this file is on your companies domain.

Isntead of reply, hit go advanced - in the additional options section there is a manage attachments section where you can browse to your file and upload it. Just make sure it does not contain any sensitive or confidential information.
etaf's Avatar
etaf   (Wayne) etaf is online now
Computer Specs
Moderator with 52,535 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
10-Jul-2012, 11:35 AM #9
Quote:
PS sorry I seem to have this q in 2 threads!
now merged
Garf13LD's Avatar
Garf13LD Garf13LD is offline
Member with 455 posts.
 
Join Date: Apr 2012
Experience: Intermediate
10-Jul-2012, 11:00 PM #10
How about using custom number format "0%" (without quotes)
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
excel, formatting, numbers, percentage

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑