View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] staeri@gmail.com is offline
external usenet poster
 
Posts: 35
Default Format amount in string

In cell A1 I have the value 10271,623 formatted as a number so it is
displayed as 10.272

In cell A2 I want to display some text and the formatted amount in cell
A1, something like:

="My text: "& A1

If I do it as above it is displayed as "My text: 10271,623" instead of
"My text: 10.272". How can I change that?

Regards,

S