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! |
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! |
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! |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com