Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 172

Truncating cells

I have a column of cells formatted as text containing a number and text i.e:
123.123 text text text
I need some way of truncating the cell to only show the number for
calculation purposes. Any Ideas?

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
numbers truncating	Sue	Excel Discussion (Misc queries)	3	January 25th 07 12:52 PM
truncating series	Michael	Charts and Charting in Excel	0	May 31st 06 11:41 AM
truncating text	scott_cairns	Excel Discussion (Misc queries)	7	May 30th 06 01:51 PM
Truncating a columns worth of cells not just a single cell.	rebates	Excel Worksheet Functions	1	July 26th 05 01:15 AM
Reduce # of pages & help truncating cells	CDAK	Excel Discussion (Misc queries)	1	June 16th 05 10:06 PM

All times are GMT +1. The time now is 08:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us