Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mistake of changing decimal into whole numbers
Earlier in the year we rec'd a spreadsheet for prices. The format was 2.30,
1.05 etc. to make it simpler, someone change it to 230, 105 and the decimals was assumed after the 1st digit. Now the customer wants it back to 2.30 vs 230 but the format has been permanently changed. Is there any hope here of changing it back? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mistake of changing decimal into whole numbers
Try this:
Put 0.01 in a blank cell Copy that cell Select the range of number you want to move the decimal point on. EditPaste Special Check: Multiply and Values Click [OK] (If that doesn't do what you want....EditUndo) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Roberta" wrote: Earlier in the year we rec'd a spreadsheet for prices. The format was 2.30, 1.05 etc. to make it simpler, someone change it to 230, 105 and the decimals was assumed after the 1st digit. Now the customer wants it back to 2.30 vs 230 but the format has been permanently changed. Is there any hope here of changing it back? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mistake of changing decimal into whole numbers
All prices are to be divided by 100:
enter 100 in an unused cell place it into the clipboard (Copy or Ctrl+C) select the cells (column) containing prices PasteSpecial, click on checkbox Division Operation Format column like number with two decimals Regards, Stefi €˛Roberta€¯ ezt Ć*rta: Earlier in the year we rec'd a spreadsheet for prices. The format was 2.30, 1.05 etc. to make it simpler, someone change it to 230, 105 and the decimals was assumed after the 1st digit. Now the customer wants it back to 2.30 vs 230 but the format has been permanently changed. Is there any hope here of changing it back? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert decimal numbers to words | Excel Worksheet Functions | |||
My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
Formula without using numbers after decimal in the answer | Excel Discussion (Misc queries) | |||
Changing Numbers | Excel Worksheet Functions | |||
Changing display of decimal value based on the value in the cell | Excel Worksheet Functions |