Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Cells
I enter 5562815 in a cell, then try to format it to currency. I've tried all
the choices and it changes to $5,562,815.00 instead of $55,628.15 like I want it to. Help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Cells
You have to retype the entry as 55628.15
Biff "amkake" wrote in message ... I enter 5562815 in a cell, then try to format it to currency. I've tried all the choices and it changes to $5,562,815.00 instead of $55,628.15 like I want it to. Help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Cells
I have a similar problem (See post Excell 2000 - Format Cell - Custom dated
12/18/2006). Martin W was kind enough to supply this suggestion ...... One way is to divide all your data by 100, by putting 100 in a blank cell, copy it, then select all your data and EditPaste Special click divide and OK. Then format them as currency with 2 decimal places and $ as the symbol. "amkake" wrote: I enter 5562815 in a cell, then try to format it to currency. I've tried all the choices and it changes to $5,562,815.00 instead of $55,628.15 like I want it to. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) |