Onrey

Posts: n/a

currency different from normal

I would like to have the values in column C formatted in either currency or
accounting, but when I try, all I get is $0.00. Can anyone tell me what to
try (or what I'm doing wrong?)

Thanks!

A B C (formula is =A1/B1)
$160.65 2,036,204 7.88945E-05
$154.80 1,993,844 7.76371E-05
$167.37 1,846,142 9.06608E-05

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
convert currency to text	Excel_Instructor	Excel Discussion (Misc queries)	8	June 15th 06 06:20 PM
Currency formating problem	Jerry	Excel Discussion (Misc queries)	5	February 19th 05 06:39 PM
Currency formating problem	jschm1957	Excel Discussion (Misc queries)	0	February 19th 05 04:09 AM
Currency conversion	Brian Collier UK	Excel Worksheet Functions	1	January 13th 05 11:23 AM
bell-shape normal distribution curve	SM	Charts and Charting in Excel	6	December 11th 04 08:29 PM

All times are GMT +1. The time now is 07:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us