Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell problem
Is there possible way to show value of 0.012 as 1.20 ?
If this is percentage answer will be very simple . Selection of custom category 0.00% would handle this , but what if I have 0.012 $ and want to see 1.20 cent in the cell without making any calculation ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell problem
If the cell is formatted for currency, and you want to keep it that way, and
you do not wish to do any caluclations, then you cannot change the appearance of the value in the cell. If you wis to use a formula in a helper cell, this will do it, but the format is no longer currency, it's TEXT....... =A1*100&" cents" Vaya con Dios, Chuck, CABGx3 "Murat Gordeslioglu" wrote: Is there possible way to show value of 0.012 as 1.20 ? If this is percentage answer will be very simple . Selection of custom category 0.00% would handle this , but what if I have 0.012 $ and want to see 1.20 cent in the cell without making any calculation ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell problem
thanks for reply but there must be a way ,
for example when I have data like 1,600 , using format cell category #,#, results in 1.6 as apperance of cell . "CLR" wrote: If the cell is formatted for currency, and you want to keep it that way, and you do not wish to do any caluclations, then you cannot change the appearance of the value in the cell. If you wis to use a formula in a helper cell, this will do it, but the format is no longer currency, it's TEXT....... =A1*100&" cents" Vaya con Dios, Chuck, CABGx3 "Murat Gordeslioglu" wrote: Is there possible way to show value of 0.012 as 1.20 ? If this is percentage answer will be very simple . Selection of custom category 0.00% would handle this , but what if I have 0.012 $ and want to see 1.20 cent in the cell without making any calculation ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Cell format problem | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Format of a cell | Excel Discussion (Misc queries) |