r/excel • u/TwicePuzzled • 25d ago

Can’t get formulas to work with large numbers solved

I’m having issues with formulas. Row A1 is formatted as text and has a 21 digit number in it. When I go to row 2 and use SUM to try and make cell A2 = A1 + 1 the cell just shows the formula instead of the new number. Any idea how to make this add up?

  • Show formulas is turned off
  • Entire column is formatted to text since they are large numbers.
  • I’ve tried both SUM and ADD functions and neither work. It just shows the formula instead of the 21 digit number.
5 Upvotes
  • permalink
  • link
  • reddit
  • reddit

86% Upvoted

33 comments sorted by

View all comments

Show parent comments

1

u/Ginger_IT 6 25d ago edited 25d ago

Though a faster way would be to iterate the 500 digits with the same requirements from my other comment.

Then B1=CONCAT("Thatfirst18digits" & A1)

Then drag down for the iterations.