teebee0831

Posts: n/a

Change a number to round up without a function

Is there a way to round numbers up so that if I enter 45.999 in cell A1, it
will display at 46 in the cell and in the formula bar?

I do not want the originally entered number to show any decimals.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
Looking for function or formula to calculate number that is revers	Ken	Excel Worksheet Functions	2	February 7th 05 11:18 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
EZ Q 4 U: How do I change a number to text, based on the number	UCD GRAD	Excel Worksheet Functions	2	November 9th 04 09:05 PM
change function variable prompts??	thinkingfield	Excel Worksheet Functions	1	November 8th 04 04:01 PM

All times are GMT +1. The time now is 06:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us