ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   decimal point in general number (https://www.excelbanter.com/new-users-excel/270705-decimal-point-general-number.html)

[email protected]

decimal point in general number
 
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?

Ron Rosenfeld[_2_]

decimal point in general number
 
On Thu, 15 Sep 2011 09:58:25 -0700 (PDT), 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?


Your question is not clear.
Perhaps some examples of the complete number and how you want it to appear, with the possible variations, would be helpful in devising a solution.

The General format will only place a decimal if the number includes a decimal.

joeu2004[_2_]

decimal point in general number
 
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.




All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com