PC Review


Reply
Thread Tools Rate Thread

decimal point in general number

 
 
sarsfieldj@bellsouth.net
Guest
Posts: n/a
 
      15th Sep 2011
I select a general number for cells, but it puts decimal points in th
number. If I remove the decimals, it rounds the number. How do I get
general numbers, i.e. check numbers, with decimals?
 
Reply With Quote
 
 
 
 
joeu2004
Guest
Posts: n/a
 
      18th Sep 2011
<(E-Mail Removed)> wrote:
> I select a general number for cells, but it puts decimal points
> in th number. If I remove the decimals, it rounds the number.
> How do I get general numbers, i.e. check numbers, with decimals?


You question is unclear.

First, when you say "general number", do you mean a cell with General
format? Or do you mean just any number?

Second, what do you mean by "check numbers"? That means "a check sequence
number" to me, which is usually an integer, not a number with decimal point
and decimal fraction. I wonder if you mean "monetary amounts" (e.g. dollars
and cents).

With the General format, Excel interprets data entry and formats it
according to undocumented rules and depending on the column width.

If you want to control the appearance of data entries, choose an appropriate
non-General format, for example Number or Currency with a specific number of
decimal places.

Nonetheless, Excel always rounds data values to fit the format. It has
nothing to do with whether or not there is a decimal point.

If the above does not help you, please provide some concrete examples.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal point in general format phoenix native Microsoft Excel Worksheet Functions 1 11th Aug 2009 06:43 PM
Text box formatted to General Number with 2 decimal places NOTallowing the decimal place. p-rat Microsoft Access Form Coding 3 14th Jan 2008 05:20 PM
in Excel 2007, how do you remove the decimal point in General =?Utf-8?B?R2lsZGVl?= Microsoft Excel New Users 2 20th Nov 2006 06:47 PM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Microsoft Excel Misc 3 18th Mar 2006 06:20 PM
Converting Hexadecimal number to floating point decimal number Fifi Microsoft Excel Misc 2 27th Oct 2004 05:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:30 PM.