 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.
-------------------- |
|
|
|
Throwdown excel question Oct 31 2006, 02:34 PM
Trespass right click: format cells: choose "number... Oct 31 2006, 02:53 PM Renegadepeon Stick a screwdriver in your monitor where that num... Oct 31 2006, 09:59 PM woody or fomat cells and select Text Nov 1 2006, 10:31 AM
Throwdown it worked, thanks Nov 1 2006, 10:33 AM |
| Lo-Fi Version | Time is now: 8th August 2026 - 04:12 PM |
