View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default 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.