Losing last zero while formating numbers to text

[nezinu]

Ok, the situation is following .. i have text in csv format(comm
delimited) ... (for example in cell A1 I have following text string
1.3456,1.5467,1.3559), and i need to change some number values include
in this text. I extracted these numbers from text with mid() function
converted to numbers format, and then made my changes. Now number
look like 1.345(A1 cell), 1.5461(A2), 1.3553(A3).Then I need to conver
these numbers back to the text and merge them in one text string an
save as CSV FORMAT. The problem is when i try to convert for exampl
number 1.345 to the text it converts like 1.345, but not 1.3450.
tried following solution: first format number with four digits behin
comma and only then convert to text .. no use, it just outputs 1.34
again

 

[AlfD]

Hi!
Try using =TEXT(A1,"0.0000")

BTW: there was nothing in your note which indicated why you had t
change from text to number to do your "thing". Could it be done b
using text functions?

Al

 

[nezinu]

Thanks AlfDDD

It really helped.
About your question .. I need to convert text to numbers, because
need to do some arithmetic operations. I don't really think that I ca
perform them without converting to the numbers

 

[AlfD]

Hi!

Thanks for the feedback.

It was just me being inquisitive in case there was another way...

Al