Thread: How to format number and not return ######
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] gavin_scott@thredbo.com.au is offline
external usenet poster
  
Posts: 3
Default How to format number and not return ######
I have formatted a number as 0.00" C/Mtres" and it returns the result
of #### because the column is too narrow.
If I don't want to make the column wider or reduce the size of the
font how do I fix this?

Reply With QuoteReply With Quote