Remember Me?

 #1     September 15th 11, 05:58 PM posted to microsoft.public.excel.newusers 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?

#2
September 15th 11, 06:34 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jun 2010 Posts: 1,045
decimal point in general number

#3
September 18th 11, 11:04 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 829
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post phoenix native Excel Worksheet Functions 1 August 11th 09 06:43 PM markx Excel Worksheet Functions 3 September 14th 07 12:10 PM BecknRoos New Users to Excel 3 April 9th 07 06:32 AM Gildee New Users to Excel 2 November 20th 06 06:47 PM Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM

All times are GMT +1. The time now is 03:40 AM.