Posted to microsoft.public.excel.misc

JulieS[_2_] JulieS[_2_] is offline

external usenet poster

Posts: 5

I want to extract the pence from a currency sum

Hello

I am working on a sheet where I need to breakdown a currency value into pounds and pence in separate columns without the pence showing the decimal point.

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
Pence per mile	Double_R	New Users to Excel	1	February 8th 09 07:31 PM
how can i convert Â£28.34 to 2834 pence	Rina	Excel Worksheet Functions	3	August 4th 06 10:29 PM
WHY IS MY CURRENCY SUM ONE PENCE OUT?	Tania	Excel Worksheet Functions	1	March 9th 06 03:23 PM
How do I add Pounds, Shillings and Pence?	alanturner12	Excel Discussion (Misc queries)	1	July 24th 05 02:45 PM
Pence field to currency?	fbm	Excel Worksheet Functions	1	April 28th 05 11:04 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us