| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving The Decimal Point Of Existing Entries
Hi Everyone, hoping someone can help me with this.
I have a massive sheet full of numbers, however, they should have been entered as values less than 1. eg - Cell has an entry of "5" and it should be "0.05" Is there anyway I can move the decimal place in the cells I want to? Thanks for your help, The Demon, Sunny Scotland |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal point | Excel Discussion (Misc queries) | |||
| How can I get a zero to appear after decimal point | New Users to Excel | |||
| Decimal point | New Users to Excel | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Threaded Mode
