If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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? 
Ads 
#2




decimal point in general number

#3




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 nonGeneral 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. 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Decimal point in general format  phoenix native  Excel Worksheet Functions  1  August 11th 09 06:43 PM 
starts with decimal point only if number is like 0.###...  markx  Excel Worksheet Functions  3  September 14th 07 12:10 PM 
Number format still uses decimal point  BecknRoos  New Users to Excel  3  April 9th 07 06:32 AM 
in Excel 2007, how do you remove the decimal point in General  Gildee  New Users to Excel  2  November 20th 06 07:47 PM 
Converting 2place decimal value to floating point decimal number with leading zero  Kermit Piper  Excel Discussion (Misc queries)  3  March 18th 06 07:20 PM 