If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

Excel 2013 Number issue

5rtytry56 · 2015-04-27 12:33:23

When I values like 300, 400, 5000, on a fresh blank sheet, they will show up as 3, 4, and 5 respectively. I have Excel 2010 on my other laptop, and it does not exhibit this behaviour. How do I correct the issue in Excel 2013?

27-04-2015 01:33PM

#1

5rtytry56

Closed Accounts Posts: 2,828 ✭✭✭

Join Date: January 2015

Posts: 2412

When I values like 300, 400, 5000, on a fresh blank sheet, they will show up as 3, 4, and 5 respectively. I have Excel 2010 on my other laptop, and it does not exhibit this behaviour. How do I correct the issue in Excel 2013?

0

Comments

#2 27-04-2015 01:41PM

Taltos

Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭

Join Date: February 2007

Posts: 19167

If you right click on one and select Properties - what format do you see?

0
#3 27-04-2015 01:44PM

Whosthis

Closed Accounts Posts: 1,342 ✭✭✭

Join Date: November 2013

Posts: 1293

Check number formatting for #, , it should be something to do with display a thousands separator , delete the #, . Sorry I can't be more specific, quite out of practice with excel and don't even have it on my current machine.

0
#4 27-04-2015 02:02PM

5rtytry56

Closed Accounts Posts: 2,828 ✭✭✭

Join Date: January 2015

Posts: 2412

Taltos -

menu.png

0
#5 27-04-2015 02:10PM

Taltos

Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭

Join Date: February 2007

Posts: 19167

Yup - select Format cells

You should see Number, up to you how many decimal places.

0
#6 30-04-2015 07:44PM

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 95,751 Mod ✭✭✭✭

Join Date: March 2003

Posts: 93988

If it wasn't for the 5000 I'd have said check for percentage format

if all else fails change to a general format
or try multiply the cell x 1 to see what it's read as - if it's not a number it won't multiply

0
Advertisement