ExcelBanter - Hyperlink Cell Format

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hyperlink Cell Format (https://www.excelbanter.com/excel-discussion-misc-queries/165005-hyperlink-cell-format.html)

coolcat999

Hyperlink Cell Format

i have a hyperlinked cell which is displayed as a number with eleven decimal
places. The source of the hyperlink is displayed as currency with 2 decimal
places.
I want the hyperlinked cell to be displayed also as currency. How can this
be done..?
I have already changed the styles of both cells, but nothing happens...????

All times are GMT +1. The time now is 05:27 AM.