Posted to microsoft.public.excel.programming

Ange[_3_]

external usenet poster

Posts: 4

I need a simple excel formula

Hello All.

I need a formula that will get rid of the decimals to the right side
of my period. The cells have to be in TEXT format.

85.10 must end up like 85

Please help,

regards

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
IF formula-simple question; simple operator	Rich D	Excel Discussion (Misc queries)	4	December 6th 07 03:36 PM
Simple problem, simple formula, no FUNCTION !	Ron@Buy	Excel Worksheet Functions	6	September 28th 07 04:51 PM
simple excel formula	Paolo Orlando	Excel Discussion (Misc queries)	1	April 5th 07 10:24 AM
Simple Excel Formula Help	robert145	New Users to Excel	7	March 17th 06 04:32 PM
simple excel formula	Jen[_10_]	Excel Programming	2	May 14th 04 01:11 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us