Posted to microsoft.public.excel.worksheet.functions

Cr character on numbers

Posts: n/a

remove cr character from a + number and change number to - 159cr

I need help I want to remove the "cr" character from + number and change the
+ number to negative on a worksheet.
Example 215,814.58cr

Result= - 215,814.58

Thank you

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
Why does last number of a 16 character number always change to 0?	FALCON	Excel Discussion (Misc queries)	2	February 7th 06 11:16 PM
How do I change a number in one cell to change a series of cells?	lance559	Excel Discussion (Misc queries)	2	January 13th 06 08:56 PM
Change number format from text to number?	Scot	New Users to Excel	2	December 1st 05 04:15 PM
Histograms: how change number of bins	[email protected]	Excel Discussion (Misc queries)	2	January 31st 05 02:07 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 12:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us