Posted to microsoft.public.excel.misc

Wanna Learn Wanna Learn is offline

external usenet poster

Posts: 318

Same column Percent and Currency

Hello I have a column that contains numbers thatr represent both
percent and currency. Presently I formatted the column as number - general
Example 0.15 and 68 - 0.15 should read 15.00% and 68 should read
$68.00. Is there a formula so that I can format the number as percent or as
currency in the same column 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
SUMPRODUCT Help	xlcharlie	Excel Worksheet Functions	4	October 6th 06 03:12 PM
Currency, Percent and Comma Style buttons	Leslie Coover	Excel Worksheet Functions	1	January 9th 06 01:02 AM
Calculating on alphabetic cell content	Thorkild	New Users to Excel	5	January 11th 05 03:12 PM

All times are GMT +1. The time now is 12:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us