| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
cut off number in excel cell vs. rounding
Disregard my formula. FIXED still rounds up. TRUNC or ROUNDDOWN would be what you are looking for. Sorry for the erroneous post. The Text to Columns solution would work as well. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=562206 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| how do i set up excel to copy from one cell to a given number of . | Excel Discussion (Misc queries) | |||
Threaded Mode
