 excel question |
  |
| excel question |
 Oct 31 2006, 02:34 PM
Post
#1
|
|
 fuck you! Group: Members Posts: 641 Joined: 22-February 06 From: fuck you! Member No.: 19  |
i'm doing a project for work on excel and i'm running in to a problem. on one of the cells, i'm listing a long number - in this case, an ebay auction # - and it's displaying it incorrectly. instead of reading out the number, it's simplifying it in to a power - for example, instead of showing 14004938294823, it shows up as 1.40049E+11. when you click on it, it will eventually show the real number, but since i'm doing this report for my mom i'm sure this will confuse the hell out of her. she isn't exactly computer savvy.
any way to change this? i haven't used excel since college -------------------- only here to talk sports occationally
|
 |
 
|
|
Oct 31 2006, 02:50 PM
Post
#2
|
|
|
Group: Admin Posts: 6,906 Joined: 22-February 06 From: Austin Member No.: 9 |
Right click on the cell -> format cells -> number -> choose category "number" with however many decimal places you want.
-------------------- |
|
|
|
|
Oct 31 2006, 02:53 PM
Post
#3
|
|
 Prize? Group: Members Posts: 302 Joined: 16-October 06 Member No.: 343 |
right click: format cells: choose "number" instead of general: change decimal to 0
|
|
|
|
|
Oct 31 2006, 09:59 PM
Post
#4
|
|
 N 0 t h i n g Group: Members Posts: 1,449 Joined: 23-February 06 Member No.: 54 |
Stick a screwdriver in your monitor where that number is displayed.
--------------------  QUOTE (jonathan83 @ Nov 16 2007, 09:22 PM)  |
|
|
|
|
Nov 1 2006, 10:31 AM
Post
#5
|
|
 Group: Moderators Posts: 2,499 Joined: 23-February 06 From: El Paso Texas Member No.: 32 |
or fomat cells and select Text
-------------------- |
|
|
|
|
Nov 1 2006, 10:33 AM
Post
#6
|
|
|
fuck you! Group: Members Posts: 641 Joined: 22-February 06 From: fuck you! Member No.: 19 |
it worked, thanks
-------------------- only here to talk sports occationally
|
|
|
|
|
| Lo-Fi Version | Time is now: 8th August 2026 - 04:19 PM |
