View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Can I show a reference value with a string?

you can also use a custom number format like

"The price is $"#,###.00

that way your cell is still a number. It only looks like a string.


" wrote:

: )

Thanks.

Best regards,
Boki.