this post was submitted on 30 May 2025
7 points (100.0% liked)
Excel
199 readers
1 users here now
A community dedicated to any discussion about Excel. QnA, Discussion of other spreadsheet applications and ancillary programming/scripting are also welcome.
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Try adding a column with the formula in row 2,
=TEXT(B2, "0.000")
, and fill down for other rows.The results should give you the text representation you need.
This worked exactly as I needed it to. Thanks so much!