Posted to microsoft.public.excel.newusers

C Tate[_2_] C Tate[_2_] is offline

external usenet poster

Posts: 7

Formatting currency query

At the moment my spreadsheet has figures in such as 303 and 528. These
numbers represent thousands. So 303 means Â£303,000 and 528 means Â£528,000.
How can I quickly change the basic figures to represent the currencies as
above? Thanks.

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
query about CURRENCY BOX??	Deonne O'Donnell	New Users to Excel	6	October 1st 06 07:18 PM
conditional formatting for currency	TC	Excel Worksheet Functions	1	May 20th 06 01:55 PM
Currency Formatting	chalky	Excel Discussion (Misc queries)	1	January 18th 06 01:51 PM
Currency Formatting.	John Smith	Excel Discussion (Misc queries)	3	November 1st 05 02:21 PM
Currency Formatting	Janbri	Excel Discussion (Misc queries)	2	July 3rd 05 03:58 PM

All times are GMT +1. The time now is 08:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us