| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Turn a four digit number into pounds & pence
Hi
I don't know if this is possible but can you turn a four digit number e.g 1234 into 12.34 in excel. I have tried many things but nothing seems to work. I have over 10,000 cells to change into this format and it would take to long for me to change them manually. The file is originally a csv file as I have been trying to upload this file to an epos tile but when the price shows up on the till it comes up in the thousands instead of the pounds and pence amount. Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to enter pre-decimal pounds shillings pence in Excel workshee | Excel Worksheet Functions | |||
| I wish to enter pounds shillings and pence in sterling | Excel Discussion (Misc queries) | |||
| How do I add Pounds, Shillings and Pence? | Excel Discussion (Misc queries) | |||
Threaded Mode
