[Neovoca]

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]

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]

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]

i have moved to business applications forum

can you load a spreadsheet with the problem and with dummy data

[GeorgeJ]

This is a duplicate post.
http://forums.techguy.org/business-a...lem-excel.html

[Neovoca]

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]

just 2 decimal places...all appears normal when I do this

[GeorgeJ]

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]

PS sorry I seem to have this q in 2 threads!

now merged

[Garf13LD]

How about using custom number format "0%" (without quotes)