123Macmini.com
FAQFAQ   SearchSearch   MemberlistMemberlist   GalleryPhoto Gallery   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Rounding in Excel

 
Post new topic   Reply to topic    123Macmini.com - Forums Forum Index -> General Software
View previous topic :: View next topic  
Author Message
iJonx
Junior Member
Junior Member


Joined: 17 Aug 2005
Posts: 41

PostPosted: Thu Sep 01, 2005 12:28 pm    Post subject: Rounding in Excel Reply with quote

I'm trying to keep a worksheet as a log book for work. The problem is that if I enter a number with a decimal, it rounds that cell to the nearest whole number. I don't want the numbers to be rounded. I know in Excel on a PC, the numbers don't round, but how can I have the numbers not round to the nearest whole number?
_________________
1.42 Ghz Mac Mini
80 GB
OWC PC2700 1GB Ram
Airport & Bluetooth
Superdrive
2 x 250 GB External LaCie Hard Drive
(1 boot drive, 1 whatever I want!)
x-x-x-x-x-x-x-x
40GB 4G iPod
60GB 5G iPod (Black)
4GB Black iPod Nano
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
sincil
Junior Member
Junior Member


Joined: 17 May 2005
Posts: 31
Location: Cheshire, United Kingdom

PostPosted: Thu Sep 01, 2005 5:55 pm    Post subject: Reply with quote

The default shouldn't be to round.
Anyway:

1. Select the cells.
2. On the Menu bar, go Format -> Cells
3. On the number tab, select an appropriate option. General should do for you.

Hope this helps.
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    123Macmini.com - Forums Forum Index -> General Software All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



      

Shop:  Apple Store  |  Refurbished Macs  |  Refurbished iPads  |  MacConnection  |  Mac Mini Vault  |  Other World Computing

MK 1 Studio Mac mini Racks  |  Crucial Mac Memory  |  Top Free Mac Apps  |  Top Paid Mac Apps



123Macmini.com is an independent publication and has not been authorized, sponsored, or approved by Apple Computer, Inc.
All logos and trademarks in this site are property of their respective owners.
Copyright © 2011 123Macmini.com. All Rights Reserved.