LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
kmuralishankar
 
Posts: n/a
Default Cannot a change a number 10.0 to 10 , cannot take out the decimal

Hi all,

I generated a report in which i get the numbers with a decimal point. EX:
12345.0 where I am supposed to get as 12345, changed the decimal settings to
zero and still no effect. I tried the default number places as zero under
options still no effect. Under format cell, Customer been kept as general.

Excel 2003 version, OS: XP.

Please someone help me in this issue as it is taking long time to format
this report for me.

Thanks
Murali
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change number when you open the excel template mowen Excel Discussion (Misc queries) 3 October 18th 05 08:05 PM
Excel ActiveX Scrollbar - change from integer to decimal Tonette Excel Discussion (Misc queries) 2 October 15th 05 03:41 PM
adding a number to every change in value Breinn Excel Discussion (Misc queries) 3 October 12th 05 06:09 PM
Change number in Text Box in Excel Jerry Dyben Excel Discussion (Misc queries) 2 September 23rd 05 02:40 AM
I want to format a number cell without the decimal and without ro. LAM Excel Discussion (Misc queries) 8 April 20th 05 04:59 PM


All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"