View Single Post
  #1   Report Post  
mate
 
Posts: n/a
Default &Text &Link 2 Dec places

I have the following:

A1="Extra Leave Entitlement = £"&D45 (where D45 is showing £75.12)

The result is showing:
Extra Leave Entitlement £75.1246883390871

I would like to restrict the result to 2 decimal places as it is a cash
value, how would i do this?

Thanks in advance

--
Jan