ExcelBanter - Number changed to Currency and ...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Number changed to Currency and ... (https://www.excelbanter.com/excel-worksheet-functions/30784-number-changed-currency.html)

Dipak

Number changed to Currency and ...

Cells formated intially as Number, 2 decimals. Changed to pound sterling
displays 1234.45.67 with leading pound sign as expected. Excel 2000
refers.
Any suggestions ? Thanks -

--
Dipak

All times are GMT +1. The time now is 05:44 PM.