decimal point in general number

S

sarsfieldj

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?
 
R

Ron Rosenfeld

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.
 
J

joeu2004

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top