LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lady112017
 
Posts: n/a
Default stop rounding in cell

i want the numbers in my cells to show as they are without being rounded but
to show in thousands. I want to maintain integrity. Eg. 97,654 should just
show as 97. i don't want it to round up or down. is this possible?
 
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
Rounding and cell totals Danny Excel Worksheet Functions 2 August 5th 05 12:54 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . Mushtaque Parker Excel Discussion (Misc queries) 0 April 24th 05 01:04 PM


All times are GMT +1. The time now is 11:35 PM.

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"